Contents Index Specifying a consolidated database Logging SQL statements as you work with a database

ASA SQL User's Guide
  Working with Database Objects
    Working with databases

Displaying system objects in a database


In a database, a table, view, stored procedures, or domain is a system object. System tables store information about the database itself, while system views, procedures, and domains largely support Sybase Transact-SQL compatibility.

In Interactive SQL, you cannot display a list of all system objects, but you can browse the contents of a system table; for more information, see Displaying system tables.

To display system objects in a database (Sybase Central)

  1. Open the desired server.

  2. Right-click the desired connected database and choose Filter Objects by Owner.

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

    The system tables, system views, system procedures, and system domains appear in their respective folders. For example, system tables appear alongside normal tables in the Tables folder.

For more information, see System Tables.


Contents Index Specifying a consolidated database Logging SQL statements as you work with a database