Difference between revisions of "Oracle:DDL Drop"
From mi-linux
Jump to navigationJump to search| (3 intermediate revisions by the same user not shown) | |||
| Line 3: | Line 3: | ||
== Removing a Table == | == Removing a Table == | ||
| − | A table can be | + | A table can be removed by using the following command: |
<code> | <code> | ||
| Line 13: | Line 13: | ||
'''Only use this if you want to get rid of a table'''. | '''Only use this if you want to get rid of a table'''. | ||
| + | For example, remove the identity_test table: | ||
| − | Do note, that if you have a foreign key linked to the table being dropped, you will not be able to remove it | + | DROP TABLE identity_test; |
| + | |||
| + | |||
| + | == Referential Integrity Issues == | ||
| + | |||
| + | Do note, that if you have a foreign key linked to the table being dropped, you will not be able to remove it: | ||
DROP TABLE DEPT; | DROP TABLE DEPT; | ||
Latest revision as of 18:20, 1 March 2016
Main Page >> Oracle and SQL >> Workbook >> DDL >> Drop
Removing a Table
A table can be removed by using the following command:
DROP TABLE tablename;
where tablename is the name of the table to be deleted.
Only use this if you want to get rid of a table.
For example, remove the identity_test table:
DROP TABLE identity_test;
Referential Integrity Issues
Do note, that if you have a foreign key linked to the table being dropped, you will not be able to remove it:
DROP TABLE DEPT;
Should return an error message:
ERROR at line 1: ORA-02449: unique/primary keys in table referenced by foreign keys
In this case the EMP table references the DEPT table, so you would have to remove it first. If you have carried out the previous CREATE TABLE section, EMP in turn is now referenced by the EMPPROP table, so it would have to be removed before the EMP and so on....
