SQLTeam.com | Weblogs | Forums

Views in SQL Server



What is the difference between WITH CHECK OPTION Clause & WITH CHECK OPTION as Constraints? Can we use a VIEW that has a WITH CHECK OPTION to enforce subquery constraints.


No. The CHECK on a view only applies to updates against the view itself, not against the underlying table.