Table Information in System Views

Information about tables in a database is in the system view SYS.SYSTAB.

You can use Interactive SQL to browse the information in this view. Type the following statement in the dbisql command window to see all the columns in the SYS.SYSTAB view:

SELECT * 
FROM SYS.SYSTAB