When a view was created without"with check option" then it will not check the condition specified in the select statement of the view during insert,update,delete when you want to check the condition specified in select statement of the view during insert,update&delete you must create the view with check option
Alter view
To alters a view use the alter view command that has the same syntax as create view command
Alter view
To alters a view use the alter view command that has the same syntax as create view command
Alter View<View Name>[(col1,.)][with Encryption] as <select statement>[with check option]
No comments:
Post a Comment