Oracle:DDL Drop
From mi-linux
Jump to navigationJump to search
Main Page >> Oracle and SQL >> Workbook >> DDL >> Drop
Removing a Table
A table can be deleted 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.
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....
