SQL Drop Command
Advertisements
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
Google Advertisment