Retrieving catalog information about a table
The SYSIBM.SYSTABLES table contains information about every table, view, and alias in your Db2 system.
About this task
The SYSIBM.SYSTABLES table
contains a row for every table, view, and alias in your Db2 system.
Each row tells you whether the object is a table, a view, or an alias,
its name, who created it, what database it belongs to, what table
space it belongs to, and other information. The SYSTABLES table also
has a REMARKS column in which you can store your own information about
the table in question.
Procedure
To retrieve catalog information about a table:
Query the SYSIBM.SYSTABLES table.
The following
example query displays all the information for the project activity
sample table:
SELECT *
FROM SYSIBM.SYSTABLES
WHERE NAME = 'PROJACT'
AND CREATOR = 'DSN8C10';