Showing system objects in a database

In a database, a table, view, stored procedure, 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 show a list of all system objects, but you can browse the contents of a system table.

StepsShowing 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. Enable SYS and dbo, and 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).

StepsBrowsing system tables (SQL)

  1. Connect to a database.

  2. Execute a SELECT statement, specifying the system table you want to browse. The system tables are owned by the SYS user ID.

Example

Show the contents of the table sys.systable in the Results pane.

SELECT *
FROM SYS.SYSTABLE