DROP COLUMN

SQL DROP COLUMN Keyword

The DROP COLUMN command is used to delete a column from an existing table.

Tutorials dojo strip

SQL DROP COLUMN Syntax

ALTER TABLE table_name
DROP COLUMN column_name

SQL DROP COLUMN Example

ALTER TABLE Patients
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.

SQL DROP COLUMN Labs

Tutorials dojo strip
Scroll to Top