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

Did you find the page informational and useful? Share it using one of your favorite social sites.

Recommended Books & Training Resources

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