Category Archives: Referential Integrity
-
Natural vs Artificial Primary Keys
6August 29, 2016 by Kenneth Fisher
There has been a long standing debate over the use of a natural primary key vs an artificial one. I …
Continue reading -
Finding, disabling and enabling foreign keys
3June 29, 2016 by Kenneth Fisher
Foreign keys are a classic method of enforcing RI (Referential Integrity). Unfortunately though, they can get in the way if …
Continue reading
SQL Studies 