Subject Re: [firebird-support] Removing Primary Keys
Author Martijn Tonies

> I would like to know the correct way to remove a primary key.
> Currently, we use both Firebird 1.0x and Firebird 1.5x for two
> different applications. I have heard you don't want to touch the
> system table directly. And I also think there is different ways in
> the 2 versions we are using. Do we just use the Alter Constraint????

ALTER TABLE name DROP CONSTRAINT constraint_name

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Upscene Productions