Skip to main content
Database Administrators

Return to Question

Tweeted twitter.com/#!/StackDBAs/status/328419870632996864
deleted 1 characters in body; edited title
Source Link
Aaron Bertrand
Aaron Bertrand
  • 181.5k
  • 28
  • 402
  • 619

How to enforce a nullable foreingforeign key?

I have a relation between two tables. The foreign key table can have a row related in the primary table. There's a way to enforce the value of the FK collumncolumn to be NULL or one of the values of the PK column in the primary table? I'm using SQL Server 2008.

How to enforce a nullable foreing key?

I have a relation between two tables. The foreign key table can have a row related in the primary table. There's a way to enforce the value of the FK collumn to be NULL or one of the values of the PK column in the primary table? I'm using SQL Server 2008.

How to enforce a nullable foreign key?

I have a relation between two tables. The foreign key table can have a row related in the primary table. There's a way to enforce the value of the FK column to be NULL or one of the values of the PK column in the primary table?

corrected spelling
Source Link
Apocatastasis
Apocatastasis
  • 605
  • 2
  • 7
  • 15

I have a relation between two tables. The foreign key table can have a row related in the primary table. There's a way to enforce the value of the FK collumn to be NULL ofor one of the values of the PK column in the primary table? I'm using SQL Server 2008.

I have a relation between two tables. The foreign key table can have a row related in the primary table. There's a way to enforce the value of the FK collumn to be NULL of one of the values of the PK column in the primary table? I'm using SQL Server 2008.

I have a relation between two tables. The foreign key table can have a row related in the primary table. There's a way to enforce the value of the FK collumn to be NULL or one of the values of the PK column in the primary table? I'm using SQL Server 2008.

Source Link
Apocatastasis
Apocatastasis
  • 605
  • 2
  • 7
  • 15

How to enforce a nullable foreing key?

I have a relation between two tables. The foreign key table can have a row related in the primary table. There's a way to enforce the value of the FK collumn to be NULL of one of the values of the PK column in the primary table? I'm using SQL Server 2008.