Views Wizard (Sybase ASE)

From DBArtisan
Jump to: navigation, search

Go Up to Sybase ASE Object Wizards

Views are SQL queries stored in the system catalog that customize the display of data contained in one or more tables. Views behave like tables because you can query views and perform data manipulation operations on them. However, views do not actually store any data. Instead, they depend on data contained in their base tables. Views can only be

To create a new view using a wizard:

  1. Open a creation wizard for a view. For details, see Opening an Object Wizard.
  2. Use the following topics as a guide to setting properties and performing tasks as you pass through the wizard panels:
  3. Finally, use the Execute button to create the object.

You can use the User Editor to assign System and Object privileges as well as create an alias.

Views (Sybase ASE) - Properties

When creating or editing a view, this tab/panel lets you work with the following settings:

Setting Description

Owner

Select the owner of the view.

Name

Provide a name for the view.

Check Type

When enabled, when a row is modified through a view, this option makes sure the data remains visible through the view after the modification is committed.

Views (Sybase ASE) - Definition

Complete the CREATE VIEW statement by typing or pasting in the relevant query.