2822597 - Error 3712: Cannot drop index '....' because it still has referential integrity constraints. - SAP ASE

•   A table was created with 2 constaints:
    
     create table my_table (
     ...
       CONSTRAINT my_pk PRIMARY KEY CLUSTERED ( my_id )  on 'default',
       CONSTRAINT my_uidx UNIQUE NONCLUSTERED ( col1, col2, col3, col4) on 'default'
     )
     ...
   
• Trying to drop the unique nonclustered index my_uidx: 
   
     ALTER TABLE my_table DROP CONSTRAINT my_uidx
   
•  Getting the following error:

Number (3712) Severity (16) State (2) Server (MYASE)
Cannot drop index 'my_table.my_uidx' because it still has referential integrity constraints.

• However, there is no referential integrity (RI) constraints on columns covered by the index my_uidx in any database.

SAP Adaptive Server Enterprise (ASE)

referencing, referenced , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem