Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - SQL Reference » Views » System views

 

Viewing detailed system information for views and definitions

Database administrators can access information about system views, including their definitions, from Sybase Central.

Prerequisites

There are no prerequisites for this task.

Context and remarks

System views are updated when a checkpoint occurs.

 Task
  1. Use the SQL Anywhere 16 plug-in to connect to the database.

  2. Right-click the database, and then click Configure Owner Filter.

  3. Click SYS, and then click OK.

  4. In the left pane, double-click Views.

  5. In the left pane click a view owned by SYS (this is indicated by the phrase SYS in parenthesis after the name of the view), and in the right pane click the SQL tab.

  6. Click the Data tab.

Results

The view definition appears on the Data tab.