In this blog post, let’s learn about the error message “1142 Because it is not audited, this table cannot have a column added that is declared NOT NULL, or has a CHECK, UNIQUE, PRIMARY KEY, or FOREIGN KEY constraint.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
1142 Because it is not audited, this table cannot have a column added that is declared NOT NULL, or has a CHECK, UNIQUE, PRIMARY KEY, or FOREIGN KEY constraint.
Reason for the Error
Internal error.
Solution
None. Contact your service provider
