Learn how to view the definition of a table in IBM DB2. You may want to view the definition of a table to see the structure of your database or specific tabl.
SHOW DETAIL. etc. See the documentation: DESCRIBE command . The above command will display db2 table structure in tabular format. Note: Tested on.
The DESCRIBE command displays metadata about the columns, indexes, and data The DESCRIBE TABLE command lists the following information about each column: Column See DB2® Text Search for information listed in the columns.
The DESCRIBE TABLE statement obtains information about a designated table (if there is a plan, authorization checking is done only against the plan owner).
For all other values, see Release dependency indicators. The value in The TABLESTATUS column indicates the reason why the table definition is incomplete.
DB2 Tables - Learn DB2 Concepts in simple and easy steps starting from their overview and Tables are logical structure maintained by Database manager.
Description of a DB2 Table. SYSCOLUMNS and find for your table and this way you would know the creator. SELECT * FROM tablename.