SQLTeam.com | Weblogs | Forums

Dropping a unique index from table in db2


#1

i WANT TO DROP A UNIQUE INDEX FROM TABLE IN DB2

This is the constraint I want to drop:
CREATE UNIQUE INDEX SQL151027015143000 ON BO_ACCESS_MODE ( CHANNEL ASC, SUBCHANNEL ASC, BEHAVIOR ASC, AML_CUSTOMER_TYPE_ID ASC, CUSTOMERLOBCODE ASC, CUSTOMEROWNERCODE ASC);

Please help


#2

See if this helps: https://msdn.microsoft.com/en-us/library/ms176118.aspx


#3

Please do refer to the help on DB2 or post in a DB2 forum.

SQL Team is on MS SQL Server


#4

I think this SQL command is standard across DBMS's:

DROP INDEX SQL151027015143000 ON BO_ACCESS_MODE;