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
The DROP VIEW statement is used to delete a view.
Syntax
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