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
- DESCRIBE
- SYSIBM.SYSCOLUMNS
- DB2LOOK
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.
Books
Related Posts