SQLTeam.com | Weblogs | Forums

Views in SQL Server

sql2012

#1

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.


#2

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