Is their a table with a list of IDENTITY columns?

iceman · #1 (**permalink**) 05-14-04, 13:49

Hi all.

Was wondering if anybody knew if there was a system table in the database that kept a list of columns that have identity values on them? This is the third time I've searched for the answer but had no luck.

sathyaram_s · #2 (**permalink**) 05-14-04, 13:56

SYSCAT.COLUMNS
Column Name : IDENTITY
Value : Y

urs_77 · #3 (**permalink**) 05-14-04, 14:09

db2 "select identity, substr(tabname,1,30), substr(colname, 1, 30) from syscat.columns"

Internet Services

Web Development

Digital Marketing

Consumer Tech