In SQL Server 2005, I've added a new table: TableNew. In an existing table, I've added a new column that is a reference to TableNew:
TableNewId will have to allow null since there are records in the table. New records will add a value in this column. Since the column allows null, is it possible to create a FK to TableNew.TableNewId? Is that needed at this point?