This example adds the column my_new_column of type TEXT to the existing table my_table:

ALTER TABLE my_table
ADD COLUMN my_new_column TEXT;

Adding multiple columns

You can also add multiple new columns at once:

ALTER TABLE my_table
ADD COLUMN my_new_column_1 TEXT,
ADD COLUMN my_new_column_2 BOOLEAN;

Get started with DB Pilot

Download DB Pilot, the database GUI with a twist.
Speed up your SQL workflows today.