SQL Codes › SQL Return Codes -1 through -999 › -178 - WITH CHECK OPTION CANNOT BE DROPPED FROM A VIEW DEFINITION

-178 - WITH CHECK OPTION CANNOT BE DROPPED FROM A VIEW DEFINITION

Explanation

During an SQL ALTER TABLE, you attempted to drop the WITH CHECK OPTION constraint from the view definition, but this is not allowed.

The SQLSTATE that equates to this SQL return code is 44S01.

User Response

Drop the view and re-create it without the WITH CHECK OPTION clause. All dependent statements and views must be rebound.