Getting catalog information about a table

The SYSTABLES view contains a row for each table and view in the SQL schema. The SYSTABLES view provides information such as the object type (table or view), the object name, the owner of the object, and the schema where the object exists.

The following example statement displays information for the CORPDATA.DEPARTMENT table:

  SELECT *
    FROM CORPDATA.SYSTABLES
    WHERE TABLE_NAME = 'DEPARTMENT';