Oracle:DDL Drop

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....

Next Step

Altering tables.