Dropping a constraint in sybase ASE [Cannot drop the constraint]

Question

I want to drop constraint of a column, like this,

alter table dbo.menu_items 
drop constraint FK_menu_items_menu_icons

but I am getting an error,

SQL Error [3701] [42S02]: Cannot drop the constraint 'FK_menu_items_menu_icons', because it doesn't exist in the system catalogs.

When I checked on menu_items table, in Properties, Foreign Keys, clearly there is FK_menu_items_menu_icons

Please help how can I fix this ?

please update the question with the complete output from `sp_helpconstraint 'dbo.menu_items'` — markp-fuso, Jul 07 '23 at 18:21
@markp-fuso problem solved, i posted an answer for this question — Jabri Juhinin, Jul 13 '23 at 04:30

score 0 · Accepted Answer · edited Jul 13 '23 at 13:08

0

Problem solved, here's the raw SQL query that works:

alter table dbo.menu_items 
drop constraint fk_menu_icons

edited Jul 13 '23 at 13:08

markp-fuso

answered Jul 13 '23 at 04:30

Jabri Juhinin

1 Answers1