SalesPersonID int NULL REFERENCES SalesPerson(SalesPersonID) You can also explicitly use the FOREIGN KEY clause and restate the column attribute. Note that the column name does not have to be the same in both tables.