All the information about tables in a database is held in the system tables. The information is distributed among several tables. For more information, see Chapter 9, “System Tables,” in Sybase IQ Reference Manual.
You can use Sybase Central or DBISQL to browse the information in these tables. Type the following command in the DBISQL command window to see all the columns in the SYS.SYSTABLE table:
SELECT * FROM SYS.SYSTABLE
Displaying system tables in Sybase Central
Connect to the database.
Right-click the database, and select Filter Objects from the pop-up menu.
Select SYS and OK.
When you view the database tables or views with Show System Objects checked, the system tables or views are also shown.
