Export (0) Print
Expand All

View Properties (General Page)

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).

Community Additions

ADD
Show:
© 2014 Microsoft