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;

Copyright 1999-2023 by Refsnes Data. All Rights Reserved.