Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
@*!! 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?
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement