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.


DROP INDEX tableName.indexName

The DROP TABLE statement is used to delete a table.


DROP TABLE tableName

The DROP VIEW statement is used to delete a view.


DROP VIEW viewName

The DROP DATABASE statement is used to delete a database.


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