View Properties

Use the view Properties wizard to access information on column datatype and permissions, and on database objects that reference, and are referenced by, the view.

Click Properties on your view to initiate the Properties wizard.

Wizard Option View Properties
General
  • View the name, type, database, owner, and creation date of the view.
SQL
  • View the SQL statements for creating the view.
Columns
  • View the name and type of all columns in the view.
Data
  • View the data for each row in the view.
Permissions
  • Grant and revoke permissions on a view to users, groups, or roles. Choose with grant to allow the grantee to further grant permissions to other users. You can grant permission to:
    • Select the view
    • Insert a row in the view
    • Update a row in the view
    • Delete a row in the view
    • Decrypt a row in the view
    Note: If restricted decrypt permission is set, only a system security officer can grant decrypt permission.
  • See Granting Permissions on Database Objects and Revoking Permissions on Database Objects.
Referenced By
  • View the name, type, owner, and properties of objects referenced by this view. Click an object, then click Properties to see the object properties.
References
  • View the name, type, owner and properties of objects that this view references. To view object properties, select an object, then click Properties.
Parent topic: Manage Views
Related tasks
Creating a View