Did you find this useful?
Socialize it today.


SQL DROP Statement

Friday, December 30, 2011

tags SQL

The SQL DROP statement can be used to delete and/or remove Indexes, tables, and databases. The syntax shown below is used on Microsoft SQL Server. Other SQL platforms have other variations of syntax.

The DROP INDEX statement is used to delete an index in a table.

Syntax

DROP INDEX tableName.indexName


The DROP TABLE statement is used to delete a table.

Syntax

DROP TABLE tableName


The DROP VIEW statement is used to delete a view.

Syntax

DROP VIEW viewName


The DROP DATABASE statement is used to delete a database.

Syntax

DROP DATABASE databaseName


Please help us spread the word by socializing it today!

email contact us

Did you find something wrong with the information on this page? Please take a moment to report it to us so that we can continue to improve the quality of the information on this site. Click here to report an issue with this page.



Recommended Books & Training Resources

Head First SQL: Your Brain on SQL A Learners Guide SQL Cookbook