SQL DROP COLUMN Keyword
The DROP COLUMN command is used to delete a column from an existing table.
SQL DROP COLUMN Syntax
SQL
x
1
ALTER TABLE table_name
2
DROP COLUMN column_name
SQL DROP COLUMN Example
SQL
1
1
ALTER TABLE Patients
2
DROP COLUMN gender;
Note: This example is not supported in SQLite, including our TechKubo playground. You cannot drop a column in an existing table using
ALTER TABLE
in SQLite.