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

Download WhatsApp Status Video

Buy This Ad Space Only $50 per Month, Ad Size 300X250