ALTER TABLE customers<br /> ADD COLUMN contact_name VARCHAR NOT NULL;<br />

ALTER TABLE table_name<br /> ADD COLUMN new_column_name data_type constraint;

ALTER TABLE customers<br /> ADD COLUMN contact_name VARCHAR NOT NULL;

ALTER TABLE table_name<br /> ADD COLUMN column_name1 data_type constraint,<br /> ADD COLUMN column_name2 data_type constraint,<br /> …<br /> ADD COLUMN column_namen data_type constraint;<br /> Code language: SQL (Structured Query Language) (sql)

ALTER TABLE table_name<br /> ADD COLUMN new_column_name data_type constraint;<br /> Code language: SQL (Structured Query Language) (sql)