What is the WITH CHECK OPTION clause?
Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.
What is the WITH CHECK OPTION clause?
Rating:
The WITH CHECK OPTION clause is used with the CREATE VIEW statement. Creating a view with the WITH CHECK OPTION clause forces all data modification statements, executed against the view, to be cancelled, if they have modified rows in a way that can cause them to disappear from the view. Therefore, all data modification statements must adhere to the criteria set within the SELECT statement defining the view.
Rating:
Was this information helpful?
Other articles
- What is the REPEATABLE READ isolation level?
- What is RAID-5?
- What is DML?
- What is database snapshot?
- Skills required for Microsoft test 70-431.