This Oracle tutorial explains how to use the Oracle DROP TABLE statement with syntax and examples. The Oracle DROP TABLE statement allows you to remove or delete a table from the Oracle database. BEGIN FOR cur_rec IN (SELECT object_name, object_type FROM user_objects WHERE object_type IN (‘TABLE’, ‘VIEW’, ‘PACKAGE’, ‘PROCEDURE’, ‘FUNCTION’, ‘SEQUENCE’ )) LOOP BEGIN IF cur_rec. SQL DROP INDEX, DROP TABLE, and DROP DATABASE. Previous Next Chapter. Indexes, tables, and databases can easily be deleted/removed with the DROP statement.
OracleRECYCLEBIN Oracle10gDrop TableWindows SQL SELEC. The Oracle error is caused by the attempt to drop a table with unique or primary keys referenced by foreign keys in another table, or in other word, the table that is referenced as a parent table by a foreign key constraint in a parent-child relationship that established between two tables through a foreign key.
Drop Table Statement