Tag Archives: Data integriy; Referential integrity; Information Schema;SQL Server Tips;

Auto-discovery of data relationships minus referential integrity

My experience is that unfortunately far too many databases lack referential integrity in the schema. There are a few reasons for this, almost all of them bad. One of the worse is the “our application controls integrity” rationale with a … Continue reading

Posted in SQL Server | Tagged | Leave a comment