Here’re SQL queries to view the Table structure in DB2. These queries helpful to get Table structure easily.
3 Top SQL Queries to See Table Structure
1. With DESCRIBE
Describe schema.table_name DESCRIBE TSY.MY_FIRST_TABLE DESCRIBE INDEXES FOR TSY.MY_FIRST_TABLE SHOW DETAIL
Here, Describe is the keyword, and “TSY” is the schema name. Finally, the Table name is my_first_table.
In the second query, you will get all the indexes defined.
SELECT * FROM SYSIBM.COLUMNS WHERE TABLE_NAME = 'MY_FIRST_TABLE';
Here, SYSIBM.COLUMNS is a catalog Table. That has a schema of “SYSIBM”. So after running this query, you will get Table details including column names and indexes.
3. Using DB2LOOK
db2look -d dbname -e -t my_first_table
Here, DB2LOOK is the system command. You can issue this command in the command line to know the Table structure in DB2.