Viewing detailed system information for views and definitions

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

Prerequisites

DBA authority.

Context and remarks

Many.

 View detailed system information for views and definitions (Sybase Central)

  1. Use the SQL Anywhere 12 plug-in to connect to the database as a user with DBA authority.

  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, and in the right pane click the SQL tab.

  6. Click the Data tab.

Results

The view definition appears on the Data tab.

Next

None.

Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1