3 Neat SQL Queries to View Table Structure in DB2

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. Use DESCRIBE
2. Use SYSIBM.SYSCOLUMNS
3. Use DB2LOCK

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.

2. SYSIBM.SYSCOLUMS

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.

Related Posts