Adding a column

Add a column with ADD COLUMN.

With ADD COLUMN you add a new column to a table. You can give a default value too.

ALTER TABLE customers
ADD COLUMN email VARCHAR(100) DEFAULT 'unknown';

This query adds an email column with default 'unknown'.

Adding a column — details

Existing rows get the default value for the new column. Without DEFAULT, NULL is used.

For example, a column added with ADD COLUMN active BOOLEAN DEFAULT TRUE starts as TRUE on every existing row.

Add an email VARCHAR(100) column to customers.

Show example solution

ALTER TABLE customers
ADD COLUMN email VARCHAR(100);

Add ADD COLUMN

ALTER TABLE customers
____ email VARCHAR(100);

Show answer

ALTER TABLE customers
ADD COLUMN email VARCHAR(100);