SQL Drop

SQL Drop Command

Drop command is used to remove the table from the database.

Syntax

 
drop table <table_name>

Example

 
drop table Employee

Note: Drop command do not drop table permanently from database. Once you drop the table then that table gone into recycle bin.

Permanently drop table from database

To drop table from recycle bin you can use purge table <table_name> command

Syntax

 
pruge table <table_name>

Example

 
pruge table Employee

Permanently drop table from database

To drop table permanently from database you can use following command

Syntax

 
drop table <table_name> pruge

Example

 
drop table Employee pruge