Hi,
Is there any SQL I can run against a DB2 table to figure out which columns have unique constraints? i.e. the values in the column have to unique.

I don't care if the column is an index or not.

Thanks.

Look in syscat.tabconst

Andy

Thanks for that.

All unique constraints (including PK's) must have a matching unique index defined. If a unique index does not already exist, DB2 creates one when the constraint is created.