The ALTER TABLE command allows you to add, modify, or drop acolumn from an existing table.
Adding column(s) to a tableSyntax #1To add a column to an existing table, the ALTER TABLE syntaxis:ALTER TABLE table_name
ADD column_name column-definition;For example:ALTER TABLE supplier
ADD supp
More...