Drop Table Oracle

At times it happens while working to a heavy amount to the database that we create some tables that are of no use. In addition to this, the database cannot hold the same variable with different values.

So, we need to delete those tables to create a new one.

Oracle Drop Table Syntax

DROP TABLE Table_name;

• DROP TABLE keyword deletes the table from the database.
• Table_name is the name of the table we want to delete.

Drop Table Oracle Example

To create table follow this article and to insert data you can view this article.

#drop table

DROP TABLE stu;