General information
Forum:
Microsoft SQL Server
Does the declarative RI allow for nulling the FK if the parent is deleted. For example, I want to keep invoices even after the client is deleted. So, if a client is delete I want to null client_id in the invoice file so that it won't break RI. I know I won't be able to leave the value there cause it wouldn't meet the FK constraint.
Thanks,
BOb
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only