Subject Re: [firebird-support] Re: Differences when adding a Primary Key
Author Ann Harrison

On Aug 21, 2015, at 2:13 PM, 'Walter R. Ojeda Valiente' sistemas2000profesional@... [firebird-support] <firebird-support@yahoogroups.com> wrote:

Without using CONSTRAINT doesn't work and in such case the name is choosed by Firebird, not for me.


For add a Primary Key to a table we can write:

ALTER TABLE MyTable ADD PRIMARY KEY (ID);

or we can write:

ALTER TABLE MyTable ADD CONSTRAINT MyPK PRIMARY KEY (ID);

In the first case, the Firebird puts the name of the Primary Key, in the second case we choose that name, but...

Why sometimes the first case fails and the second case always work?

But (just sometimes) the first case fails.


How does it fail?  What's the error message? Or does it kill the connection?  Crash the server?  Freeze the O/S?  Set the machine on fire?

Cheers,

Ann