If a view was created with the WITH READ ONLY 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 READ ONLY 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

To remove the WITH READ ONLY constraint from a view, you must re-create the view without this option, as there is no direct command to alter this aspect of a view after it has been created.

If a View Was Created with the WITH READ ONLY