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 sample statement displays information for the CORPDATA.DEPARTMENT table:

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

 

Parent topic:

Catalogs in database design