Add or drop a column

You can add or drop table columns. If you add a column, you can provide a default value. You must be the owner of the table or have the Alter privilege on tables to add or drop columns. You cannot add or drop a column in a transaction block.

To add a column, enter:

   MYDB.SCHEMA(USER)=> ALTER TABLE table_name ADD [COLUMN] column_name 
type [ column_constraint [ constraint_characteristics ] ] [, ... ];

To drop a column, enter:

   MYDB.SCHEMA(USER)=> ALTER TABLE table_name DROP [COLUMN] column_name [, 
... ];