> ALTER TABLE TEST ADD CONSTRAINT PRIMARY KEY PK_TEST
> (OBJECTID, USERINSTID);
>
> Doesn't work. Is this a bug of Firebird SQL?
>
> I had a script that creates a number of tables then adds primary key to
fields. The
> script worked fine. Created tables. But no constraints added to table.
What about
ALTER TABLE TEST ADD CONSTRAINT PK_TEST
PRIMARY KEY (OBJECTID, USERINSTID);