DROP Keyword

The Drop keyword is used to delete existing tables, databases, views, indexes, etc.

The Drop keyword is also used to delete an existing column or constraints from a table.

DROP DATABASE

The Drop Database keyword is used to delete an existing database in SQL.

Syntax

SQL
DROP DATABASE <DATABASE_NAME>;

Example

SQL
DROP DATABASE MyDB;

DROP TABLE

The Drop Table keyword is used to delete an existing table from a database.

Syntax

SQL
DROP TABLE <TABLE_NAME>;

Example

SQL
DROP TABLE Employee;

DROP VIEW

The Drop View keyword is used to delete an existing view from a database.

Syntax

SQL
DROP VIEW <VIEW_NAME>;

Example

SQL
DROP VIEW Employee_Male_V;

DROP INDEX

The Drop Index keyword is used to delete an index in a table.

Syntax

SQL
DROP INDEX <TABLE_NAME.INDEX_NAME>;

Example

SQL
DROP INDEX Employee.My_Index;

DROP COLUMN

The Drop Column keyword is used to delete a column in an existing table.

Syntax

SQL
ALTER TABLE <TABLE_NAME> DROP COLUMN <COLUMN_NAME>;

Example

SQL
ALTER TABLE Employee DROP COLUMN Emp_Gender;

DROP CONSTRAINT

The Drop Constraint keyword is used to delete a constraint in an existing table.

Syntax

SQL
ALTER TABLE <TABLE_NAME> DROP CONSTRAINT <CONSTRAINT_NAME>;

Example

SQL
ALTER TABLE Employee DROP CONSTRAINT Chk_EmpAge;

Summary

The Drop keyword is used to delete something in SQL like a database, table, view, index, or also delete a column or constraint from a table.