ALTER TABLE

Change an existing table.

ALTER TABLE changes an existing table's structure. Add, drop or modify columns.

ALTER TABLE products
ADD COLUMN stock INT;

This query adds a stock column to products.

ALTER TABLE — details

ALTER TABLE updates the table without losing data. Beware of locking on large tables.

For example, ALTER TABLE customers ADD COLUMN phone VARCHAR(20) adds a phone column without deleting existing customer records.

Add a stock INT column to products.

Show example solution

ALTER TABLE products
ADD COLUMN stock INT;

Add ALTER TABLE

____ products
ADD COLUMN stock INT;

Show answer

ALTER TABLE products
ADD COLUMN stock INT;