View Properties (General Page)

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

Options

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