|Subject||Re: [ib-support] Firebird SQL - Alter table command (does it work?) - BUG?|
> Create a database test.gdb. Create a table test with fields objectid(Integer),
> userid (Integer), name (Varchar). Then try to add primary key constraintto the
> first 2 fields:fields. The
> 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
> script worked fine. Created tables. But no constraints added to table.USERINSTID and userid are different fields isn't that the problem ?