Description of the illustration drop _ table. Specify the schema containing the table. Oracle Database automatically performs the following operations: All rows from the table. The Oracle DROP TABLE statement allows you to remove or delete a table from the Oracle database.
Summary: in this tutorial, you will learn how to use the Oracle DROP TABLE statement to remove an existing table. Introduction to Oracle DROP TABLE statement. To drop a table that you no longer nee use the DROP TABLE statement. The table must be contained in your schema or you must have the DROP ANY TABLE system privilege.
The SQL DROP TABLE Statement. The DROP TABLE statement is used to drop an existing table in a database. It’s called DROP because that’s the standard term for deleting objects from a database. The DELETE keyword is used when you want to delete data from a table (or materialized view ). DROP TABLE cannot be used to drop a table that is referenced by a FOREIGN KEY constraint. The referencing FOREIGN KEY constraint or the referencing table must first be dropped.
If both the referencing table and the table that holds the primary key are being dropped in the same DROP TABLE statement, the referencing table must be listed first. Why are you trying to drop and recreate tables at run-time?