mssql can foreign key be null?
You define a foreign key with the FOREIGN KEY clause in the CREATE TABLE or ALTER TABLE statement. A foreign key makes its table dependent on another table called a parent table. ... A foreign key containing null values cannot match the values of a parent key, since a parent key by definition can have no null values.