SQL Drop Command

Advertisements

Delete Command in SQL Update Command in SQL

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

Delete Command in SQL Update Command in SQL

Google Advertisment

Buy This Ad Space @$20 per Month, Ad Size 600X200 Contact on: hitesh.xc@gmail.com or 9999595223

Magenet is best Adsense Alternative here we earn $2 for single link, Here we get links ads. Magenet

For Projects 9999595223

Google Advertisements


Buy Websites 9999595223

Buy College Projects with Documentation Contact on whatsapp 9999595223. Contact on: hitesh.xc@gmail.com or 9999595223 Try this Keyword C++ Programs

Advertisements