Showing System Objects in Interactive SQL

In Interactive SQL, you cannot query system tables, but you can browse the contents of a system view.

Most system tables have equivalent system views that you can query.

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.

  1. Connect to a database using Interactive SQL.
  2. Execute a SELECT statement, specifying the system view for the table you want to browse.

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

    SELECT *
    FROM SYS.SYSTAB