View Editor

Use the View Editor to view the columns and definitions of a view and to control the priviliges assigned to a view object.

Table 1. View Editor tabs
Tab Description
Columns Displays the owner and selected columns for the view, including the column names, the column datatypes, and whether each column is nullable.
Instead of Triggers (ASE 15.0.2 or later) Lists the defined INSTEAD OF triggers for the view. You can add a new INSTEAD OF trigger, edit an existing trigger, or delete a trigger from the view.
Source View or edit the view definition.
Permissions Displays permissions status for user, group, and role grantees for the select, insert, update, and delete operations:

  • G indicates permission for the specified operation has been granted.
  • GO indicates permission for the specified operation has been granted with the grant option.
  • I indicates permission for the specified operation has been inherited.
  • RI indicates inherited permission for the specified operation has been revoked.
DDL Displays the Transact-SQL DDL for the view.
Related tasks
Creating a Table
Creating a Database View
Opening a Database View
Dropping a Database View
Executing View DDL
Creating a Database View
Opening a Database View
Dropping a Database View
Executing View DDL


Created June 25, 2009. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com