Hi,

> 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
Server.
Upscene Productions
http://www.upscene.com