ASA SQL User's Guide
Working with Database Objects
Working with tables
In a database, a table, view, stored procedure, or domain is a system object. System tables store the database's schema, or information about the database itself. System views, procedures, and domains largely support Sybase Transact-SQL compatibility.
All the information about tables in a database appears in the system tables. The information is distributed among several tables.
For more information, see System Tables.
To display system tables (Sybase Central)
Right-click the desired connected database and choose Filter Objects by Owner from the popup menu.
Select the checkbox beside SYS 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.
To browse system tables (SQL)
Connect to a database.
Execute a SELECT statement, specifying the system table you want to browse. The system tables are owned by the SYS user ID.
Display the contents of the table sys.systable on the Results tab in the Results pane.
SELECT * FROM SYS.SYSTABLE