Difference between revisions of "DROP a table"

From SQLZOO
Jump to: navigation, search
(Created page with "DROP an unwanted table <div class='ht'> <div class=params>schema:scott</div> <div> Naturally, all of the data in the table is lost when the table is dropped. Foreign Key refe...")
 
 
Line 7: Line 7:
 
Foreign Key references can cause problems.
 
Foreign Key references can cause problems.
 
</div>
 
</div>
 +
 
<source lang=sql class='tidy'></source>
 
<source lang=sql class='tidy'></source>
 
<source lang=sql class='setup'>CREATE TABLE t_test
 
<source lang=sql class='setup'>CREATE TABLE t_test

Latest revision as of 10:14, 17 July 2012

DROP an unwanted table

schema:scott

Naturally, all of the data in the table is lost when the table is dropped.

Foreign Key references can cause problems.

 
CREATE TABLE t_test
 (a INTEGER NOT NULL PRIMARY KEY
 ,b VARCHAR(10)
 )
DROP TABLE t_test
Personal tools
Namespaces

Variants
Actions
Reference
Toolbox
Google AdSense