DB2 10.5 for Linux, UNIX, and Windows

Viewing table definitions

You can use the SYSCAT.TABLES and SYSCAT.COLUMNS catalog views to view table definitions. For SYSCAT.COLUMNS, each row represents a column defined for a table, view, or nickname. To see the data in the columns, use the SELECT statement.

About this task

You can also use the following views and table functions to view table definitions:

ADMINTEMPCOLUMNS administrative view
ADMINTEMPTABLES administrative view
ADMIN_GET_TEMP_COLUMNS table function - Retrieve column information for temporary tables
ADMIN_GET_TEMP_TABLES table function - Retrieve information for temporary tables