List DB2 table columns and unique constraints

18 May,2013 by Jack Vamvas

How can I list the DB2 table columns and unique constraints?

 To list DB2 table columns and constraints  use one of these methods – using syscat.columns , describe or db2look

--Method 1 – query syscat.columns
select colname from syscat.columns where tabname='ADDRESS'

--Method 2 – use the describe command
describe table dbo.address

--Method 3 –use db2look 
db2look  -e –d dbname –t tablename


Read More

DB2 - Collecting data for database performance problems - DBA DB2

DB2 – COPY a table - DBA DB2

DB2 Tuning Toolkit – DB2 Design advisor - Ddb2advis - DBA DB2


Author: Jack Vamvas(


Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Your comment could not be posted. Error type:
Your comment has been saved. Comments are moderated and will not appear until approved by the author. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.


Post a comment on List DB2 table columns and unique constraints

Comments are moderated, and will not appear until the author has approved them. | DB2 Performance Tuning | DBA DB2:Everything | FAQ | Contact | Copyright