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 procedures, and domains largely support Sybase Transact-SQL compatibility.

In Interactive SQL, you cannot query system tables, you can browse the contents of a system view. Most system tables have equivalent system views that you can query

StepsShowing system objects in a database (Sybase Central)

  1. Open the server.

  2. Right-click the connected database and choose Configure Owner/Container Filtering.

  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).The system views are owned by the SYS user ID.

StepsQuerying system views (SQL)

  1. Connect to a database using Interactive SQL.

  2. Execute a SELECT statement, specifying the system view for the table you want to browse.

Example

To browse the ISYSTAB system table, show the contents of the view SYS.SYSTAB in the Results pane.

SELECT *
FROM SYS.SYSTAB