SAP Knowledge Base Article - Preview

2840399 - How to drop a primary key constraint - SAP ASE


  • A table is created with a primary key as below.

create table test1 (
col1 int,
col2 char(10),
primary key nonclustered (col1)
lock datarows

  • sp_helpindex shows the primary key exists.

sp_helpindex test1
Object has the following indexes
index_name index_keys index_description index_max_rows_per_page ......
---------------- ---------- -------------------- ----------------------- ......
test1_7520026792 col1 nonclustered, unique 0 ......

  • When running DROP INDEX command to drop the primary key, a 3710 error is raised.

drop index test1.test1_7520026792
Msg 3710, Level 16, State 2:
Server '<ASE name>', Line 1:
Cannot use DROP or REPLACE with 'test1.test1_7520026792' because 'test1_7520026792' is a constraint. Use ALTER TABLE.



SAP Adaptive Server Enterprise All version


SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0


KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , How To

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.