How to drop a unique constraint through alter table

[falom]

Hi,

I created a DB2 table with "UNIQUE (columnX, columnY)" in the table definition, but i now want to drop it with help of alter table, but i could not find out the name of this unique constraint with which i can drop it ("alter table drop unique" does not work directly). And i of course can not drop the DB2 generated index directly. What should i do?

 

[leveyp]

Have a look in SYSIBM.CHECK_CSTS OR SYSIBM.TABLE_CSTS