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

SQL Anywhere 12.0.0 (Français) » SQL Anywhere Server - SQL Usage » Working with database objects


View system objects in a database

System objects such as system tables, system views, stored procedures, and domains hold information about database objects, and how they are related to each other. System views, procedures, and domains largely support Sybase Transact-SQL compatibility.

 ♦  To display system objects in a database (Sybase Central)
  1. Use the SQL Anywhere 12 plug-in to connect to the database as a user with DBA authority.

  2. Select the database and choose File » Configure Owner Filter.

  3. Select SYS, and dbo, and then click OK.

 ♦  To browse system objects (SQL)
  1. Connect to a database.

  2. Execute a SELECT statement, querying the SYSOBJECT system view for a list of objects.

 See also