Subject Re: [firebird-support] Null Foreign Keys
Author Milan Babuskov
Ed Dressel wrote:
> Does FB support null foreign keys? I though I saw mention of this but
> can not find anything on it.

Why can't you just test?

Here:
SQL> create table a ( x int not null, primary key (x));
SQL> create table b ( y int);
SQL> commit;
SQL> alter table b add constraint c foreign key (y) references a(x);
SQL> commit;
SQL> insert into b values (null);
SQL> commit;

As you can see, I have inserted NULL in FK column. Does that answer the
question?

--
Milan Babuskov
http://fbexport.sourceforge.net