Delete Unique Index in DB2: Quick Guide

1 year ago
William Carter
1 minute

In DB2, you can use the ALTER TABLE statement to drop a unique index. Below is the basic syntax for deleting a unique index.

ALTER TABLE table_name DROP CONSTRAINT constraint_name

Please replace table_name with the name of the table from which you want to remove the unique index, and replace constraint_name with the name of the unique index you wish to delete. You can use the following query to find the name of the unique index:

SELECT CONSTRAINTNAME 
FROM SYSCAT.INDEXES 
WHERE TABSCHEMA = 'schema_name' AND TABNAME = 'table_name' AND UNIQUERULE = 'U'

Please replace schema_name and table_name with the corresponding schema and table names. Then, use the constraint_name found to execute the ALTER TABLE statement to drop the unique index.

bannerAds