The DROP TABLE statement in PLSQL allows us to delete or drop a table from the database.
It is a Data Definition Language (DDL) statement.
Syntax for the DROP TABLE statement in PLSQL is:
DROP TABLE table_name;
Let’s take an example for understanding:
Suppose have a table named “Employee” as shown below in database.
If we want to delete the ’employee’ table from the database we use the DROP TABLE statement as follows:
DROP TABLE employee;
The above statement will delete the table ’employee’ from the database.