SAP Knowledge Base Article - Preview

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

Symptom

  •   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.



Environment

SAP Adaptive Server Enterprise (ASE)

Product

SAP Adaptive Server Enterprise all versions

Keywords

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

About this page

This 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.