In this blog post, let’s learn about the error message “1176 Column column-name has DEFAULT NULL and cannot be referenced by NOT DROPPABLE constraint constraint-name.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
1176 Column column-name has DEFAULT NULL and cannot be referenced by NOT DROPPABLE constraint constraint-name.
Reason for the Error
You attempted to create a table with a column that has DEFAULT NULL, and which is referenced by an IS NOT NULL predicate in a NOT DROPPABLE check constraint.
Solution
Determine whether the column should be DEFAULT NULL or NOT NULL and resubmit
