Browsing data in a regular view

You can browse data in a regular view. Regular views are stored in the database as definitions for the view. The view is populated with data when it is queried so that the data in the view is current.

Prérequis

The regular view must already be defined and be a valid view that is enabled.

You must be the owner, or have one of the following privileges:

SELECT privilege on the view
SELECT ANY TABLE system privilege

Contexte et remarques

This task starts in Sybase Central, where you request the regular view that you want to view, and completes in Interactive SQL, where the data for the regular view is displayed.

Task

In Sybase Central, use the SQL Anywhere 16 plug-in to connect to the database.
In the left pane, click Views.
Select a view and then click File » View Data In Interactive SQL.

Résultat

Interactive SQL opens with the view contents displayed on the Results tab of the Results pane.

Browsing data in a regular view

Task

See also