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.

Advertisements

3 Top SQL Queries to See Table Structure

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

The illicit happiness

Related Posts

Rating: 4.5 out of 5.

Author: Srini

Experienced software developer. Skills in Development, Coding, Testing and Debugging. Good Data analytic skills (Data Warehousing and BI). Also skills in Mainframe.