Difference between revisions of "DROP a table"
From SQLZOO
(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 09: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
DROP a table
