Oracle Tutorial

What is Oracle
SQL Keywords

Oracle Wildcards

Oracle Wildcards

Oracle Aliases

Oracle Aliases

MySQL Tutorial

MySQL Tutorial

PL/SQL Tutorial

PL/SQL Tutorial

Oracle Interview Questions

Oracle Interview Questions and Answers

Oracle Drop Table

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 (,).

Oracle DROP TABLE Syntax

To remove existing table, use the following syntax:


DROP TABLE tablename [, table_name] ...


oldtablename: The old table name that you want to rename.

newtablename: The new table name for the existing table.

Oracle Drop TABLE example

The following Oracle statement to remove existing table:


DROP TABLE tblCustomer;


In the above example, we removed the existing table "tblCustomer" from database.