databasesybasesybase-ase15

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

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 ?

Solution

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

    alter table dbo.menu_items 
drop constraint fk_menu_icons