Sunday, August 12, 2012

View with check option in sql server

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<View Name>[(col1,.)][with Encryption] as <select statement>[with check option]

No comments: