This topic has not yet been rated - Rate this topic

View Properties (General Page)

SQL Server 2008

Other Versions

Displays information about a view. All information is read-only.

Database: The name of the database containing this view.
Server: The name of the current server instance.
User: The name of the user of this connection.
Created date: Displays the date the view was created.
Name: The name of the current view.
Schema: Displays the schema that owns the view.
System object: Indicates whether the view is a system object. Values are True and False.
ANSI NULLs: Indicates if the object was created with the ANSI NULLs option.
Encrypted: Indicates whether the view is encrypted. Values are True and False.
Quoted identifier: Indicates if the object was created with the quoted identifier option.
Schema bound: Indicates whether the view is schema-bound. Values are True and False. For information about schema-bound views, see the SCHEMABINDING portion of CREATE VIEW (Transact-SQL).

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions