-7004: DEFAULT not allowed



       1.      Columns with DEFAULT specification cannot be added to a table with the ALTER TABLE statement.

       2.      The specification of NOT NULL DEFAULT NULL is not allowed.

User Action:


       1.      To add a column to one with an <ALTER TABLE statement>, specify it without a DEFAULT specification. Then define the DEFAULT in another <ALTER TABLE statement>. This how this column is given the DEFAULT value in all table rows.

       2.      Delete the DEFAULT specification from the SQL statement and execute the statement again.