SQL Drop Command


Prev Tutorial Next Tutorial

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

Prev Tutorial Next Tutorial

Advertisements




Download Projects

Advertisements

FREE Online Google Play APK Downloader

Buy APP Installs, Buy 100% Genuine Installs