Subject Re: [firebird-support] Re: Alternative for UNIQUE constraint
Author Mark Rotteveel
Helen Borrie wrote:
>>> Another comment: that's not a valid table declaration
>>> have to declare a FOREIGN KEY constraint explicitly and it's not a
>>> great idea to try and declare FK constraints in the same
>>> transaction as you define the will likely cause your
>>> next exception, after you deal with the index overflow issue.
>> Ah, thanks for the heads up. I've never really used databases before and guides for getting started don't mention this kind of stuff, so I just worked off the IB 6 language reference for what was and wasn't possible.
> It's wrong according to the LangRef, though.

Actually according to the LangRef it is allowed (see the syntax on page
72, and the notes on page 77-78).

Mark Rotteveel