If a view was created with the WITH CHECK OPTION constraint,to remove the constraint you will need to ____.
A) use the ALTER VIEW command
B) re-create the view without the option
C) rename the view
D) drop the option

Question

If a view was created with the WITH CHECK OPTION constraint,to remove the constraint you will need to ____.​
A) ​use the ALTER VIEW command
B) ​re-create the view without the option
C) ​rename the view
D) ​drop the option

Quizplus · Accepted Answer

The WITH CHECK OPTION constraint is a part of the view definition, so it cannot be altered or dropped using ALTER VIEW command. The only way to remove the constraint is to drop and recreate the view without the option. Therefore, option B is the correct choice.

If a View Was Created with the WITH CHECK OPTION