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 for Me (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.