FK column is automatic not null ?

chomik · #1 (**permalink**) 11-08-09, 08:10

column which is PK is automatic not null. What about FK column - is it also automatic not null or I must add not null to this column ?

LKBrwn_DBA · #2 (**permalink**) 11-08-09, 09:05

You need to add the NOT NULL constraint if that is the requirement, otherwise you can leave as NULL if nulls are permitted.

chomik · #3 (**permalink**) 11-08-09, 09:29

ok thx, I thought that FK columns are automatic not null as PK columns

Littlefoot · #4 (**permalink**) 11-08-09, 15:48

No need to presume when you can easily try it. Can't you?