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
- Use DESCRIBE
- Use SYSIBM.SYSCOLUMNS
- 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.
Here’s more on Oracle-SQL-ultimate-experience
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
Get new content delivered directly to your inbox.