Oracle Drop TABLE statement removeor delete the existing table from database. The DROP TABLE statement not only removes a table but also remove its structure and data permanently from the database. In Oracle, you can remove multiple tables using a single DROP TABLE statement, each table is separated by a comma (,).
To remove existing table, use the following syntax:
Parameters:
oldtablename: The old table name that you want to rename.
newtablename: The new table name for the existing table.
Note:
In the above example, we removed the existing table "tblCustomer" from database.