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


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

Recommended Books & Training Resources

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