Background documentation-8021: Column must have DEFAULT specification Locate this document in the navigation structure

 

Explanation

The attempt was made to specify the action SET DEFAULT as DELETE RULE in a referential CONSTRAINT definition, although no DEFAULT value had been defined for at least one section of the referencing column.

User Response

  1. If the error occurred during the execution of a CREATE TABLE statement, either define a DEFAULT value for the column(s) or choose another action.

  2. If the error occurred during the execution of an ALTER TABLE statement, issue another ALTER TABLE statement to assign a DEFAULT value to all columns (referencing column) without a DEFAULT value and then repeat the previous ALTER TABLE statement. Alternatively, you may choose another action.