Wednesday, 12 October 2011

What is Check optionForce View

{\rtf1\ansi\ansicpg1252\deff0\deflang16393{\fonttbl{\f0\froman\fprq2\fcharset0 Times New Roman;}{\f1\fnil\fcharset0 Calibri;}}
{\*\generator Msftedit 5.41.21.2509;}\viewkind4\uc1\pard\li720\lang1033\f0\fs22\par
\pard\li1020\b FORCE\b0 : creates the view regardless of whether the view's base tables exist or the owner of the schema containing the view has privileges on them. Note that both of these conditions must be true before any SELECT, INSERT, UPDATE, or DELETE statements can be issued against the view. \par
\b WITH CHECK OPTION\b0 : specifies that inserts and updates performed through the view must result in rows that the view query can select. The CHECK OPTION cannot make this guarantee if there is a sub query in the query of this view or any view on which this view is based. \par
\pard\sa200\sl276\slmult1\lang9\f1\par
}

No comments:

Post a Comment