Refresh

This website onedoubt.com/post/537/drop-column is currently offline. Cloudflare's Always Online™ shows a snapshot of this web page from the Internet Archive's Wayback Machine. To check for the live version, click Refresh.

SQL DROP COLUMN Keyword


DROP COLUMN

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

The following SQL deletes the "ContactName" column from the "Customers" table:

Example

ALTER TABLE Customers
DROP COLUMN ContactName;


Login
ADS CODE