Add Columns

Use the alter table command to add a column to an existing table.

This is an example adding on a non-null column named author_type, which includes the constant “primary_author” as the default value, and a null column named au_publisher to the authors table.
alter table authors
add author_type varchar(20)
default "primary_author" not null,
au_publisher varchar(40) null