How to add column to a table in Redshift

Below is the syntax to add a new column to an existing table in Redshift database.

ALTER TABLE table_name ADD COLUMN column_name datatype;

Example:

ALTER TABLE person ADD COLUMN email varchar(100);