Background documentation-7004: DEFAULT not allowed Locate this document in the navigation structure

 

Explanation

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

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

User Response

  1. To add a column with an ALTER TABLE statement, specify it without a DEFAULT specification. Then define the DEFAULT in another ALTER TABLE statement. This way, the column ends up with the DEFAULT value in all table rows.

  2. Repeat the SQL statement after removing the DEFAULT specification.