Dropping a column

Remove a column with DROP COLUMN.

With DROP COLUMN you remove a column from a table. The column data is deleted.

ALTER TABLE products
DROP COLUMN stock;

This query removes the stock column.

Dropping a column — details

DROP COLUMN cannot be undone. All data in the column is lost. Backup before using it.

For example, ALTER TABLE customers DROP COLUMN fax permanently deletes every stored fax number.

Drop the stock column from products.

Show example solution

ALTER TABLE products
DROP COLUMN stock;

Add DROP COLUMN

ALTER TABLE products
____ stock;

Show answer

ALTER TABLE products
DROP COLUMN stock;