How can we add and delete columns in a table?

SQL DROP COLUMN Keyword Previous SQL Keywords Reference Next DROP COLUMN The DROP COLUMN command is used to delete a column i

How can we add and delete columns in a table?

SQL DROP COLUMN Keyword  Previous SQL Keywords ReferenceNext


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; Try it Yourself »  
Previous SQL Keywords ReferenceNext

Video liên quan