View Properties (General Page)

  • Article

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