General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
@*!! Why does Referential Integrity bother with deleted recs
The code generated by the RI builder checks for referential integrity on deleted records.
This is a total pain.
Does anybody know why this was thought neccesary or is it just a load of purist nonsense that we will laugh about in a few years.
Has anyone tried altering the RI code so that it does not do this?
At first glance it just looks like at case of changing all the
SET DELETED OFF to SET DELETED ON
Has anyone tried this?
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