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.

The View Editor consists of four tabs.

Table 1. View Editor tabs
Tab Description
Introduction This tab provides introductory information with links to the Columns tab and online help.
Columns This tab shows the owner and name for the specified view and a description of the view columns, including the column names, the column datatypes, and whether or not each column is nullable.
Privileges This tab shows 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 This tab displays the Transact-SQL DDL for the view.
Related tasks
Creating a Table
Creating a Database View
Editing a Database View
Dropping a Database View
Executing View DDL

For product-related issues, contact Sybase Technical Support at 1-800-8SYBASE. Send your feedback on this help topic directly to Sybase Technical Publications: pubs@sybase.com