Difference between revisions of "Oracle:DDL Drop"
From mi-linux
Jump to navigationJump to search| Line 3: | Line 3: | ||
== Removing a Table == | == Removing a Table == | ||
| − | A table can be deleted by using the following command | + | A table can be deleted by using the following command: |
<code> | <code> | ||
| Line 10: | Line 10: | ||
where tablename is the name of the table to be deleted. | where tablename is the name of the table to be deleted. | ||
| + | |||
'''Only use this if you want to get rid of a table'''. | '''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 | + | 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; | ||
| + | |||
Should return an error message: | Should return an error message: | ||
Revision as of 18:17, 1 March 2016
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....
