Delclarative RI in SQL Server 2005

Does anyone know if in SQL Server 2005 declarative RI can be used to NULL a
referenced field on delete of a record from the parent table?

Any help is appreciated.

Don

Yes, there is a SET NULL option when the foreign key constraint is created.
The foreign key column(s) must of course be nullable.

--
Happy Holidays

Dan Guzman
SQL Server MVP

"Don" <Don@discussions.microsoft.com> wrote in message
news:FC073BAB-8767-44C7-9FDC- CACF6E66AC84@microso
ft.com...
> Does anyone know if in SQL Server 2005 declarative RI can be used to NULL
> a
> referenced field on delete of a record from the parent table?
>
> Any help is appreciated.
>
> Don

Thank you very much

"Dan Guzman" wrote:

> Yes, there is a SET NULL option when the foreign key constraint is created
.
> The foreign key column(s) must of course be nullable.
>
> --
> Happy Holidays
>
> Dan Guzman
> SQL Server MVP
>
> "Don" <Don@discussions.microsoft.com> wrote in message
> news:FC073BAB-8767-44C7-9FDC- CACF6E66AC84@microso
ft.com... 
>
>
>