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
See if this helps: https://msdn.microsoft.com/en-us/library/ms176118.aspx
Please do refer to the help on DB2 or post in a DB2 forum.
SQL Team is on MS SQL Server
I think this SQL command is standard across DBMS's:
DROP INDEX SQL151027015143000 ON BO_ACCESS_MODE;