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
About this pageThis is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.