Nullable foreign keys

In my SQL Server 2005 T-SQL book, it mentions that SQL Server 2005 now allows you to set Foreign Key Update/Delete Rules to "Set Null" and "Set Default". In Management Studio, I only see "No Action" and "Cascade" as options. I wish to have the foreign key field set to null when the Primary key in the other table is deleted. Does anyone know why these options aren't showing up, or what I can do to achieve this result? Thanks.

Al

Hi,

simply navigate to Modify Foreign key, the following screen should come up:

http://www.sqlserver2005.de/SharedFiles/FKSetNull.JPG

HTH, jens Suessmeyer.

http://www.sqlserver2005.de
|||That's what I am talking about. The only options are No Action and Cascade. I am using SQL Server 2005 Express (The one shipped with VS 2005) in my devlopment environment, but I don't see why this feature wouldn't be there.