Meta-data
The OBJECTPROPERTY() meta-data function supports a number of properties that relate to views. Table 9-1 summarizes them.
Property | Function |
---|---|
ExecIsAnsiNullsOn | Indicates whether ANSI_NULLS was on when the view was created or altered |
ExecIsQuotedIdentOn | Indicates whether QUOTED_IDENTIFIER was on when the view was created or altered |
HasAfterTrigger | Indicates whether the view has an AFTER trigger |
HasInsertTrigger | Indicates whether the view has an INSERT trigger |
HasInsteadOfTrigger | Indicates whether the view has an INSTEAD OF trigger |
HasUpdateTrigger | Indicates whether the view has an UPDATE trigger |
IsAnsiNullsOn | Indicates whether ANSI_NULLS was on when the view was created or altered (same as ... |
Get Guru's Guide to SQL Server™ Stored Procedures, XML, and HTML, The now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.