SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Articles with tag Referential Integrity Rss

Search for any content tagged referential integrity

   Items 1 to 5 of 5   

Foreign Key Indexes and Binding

Understand what FK's do and how they use indexes. Then use my script to see if they're using good indexes.  Read more...
By Steve Hood 2016/02/10 | Source: SQLServerCentral.com | Category: foreign keys (fk)
Rating: |  Discuss |   Briefcase | 3,289 reads

Why is data integrity important?

Why should I care and why should the database enforce it? This article from Jamin VanderBerg gives some reasons why the database is the place to enforce rules that ensure integrity.  Read more...
By Jamin VanderBerg 2010/08/30 | Source: SQLServerCentral.com | Category: data integrity
Rating: |  Discuss |   Briefcase | 3,671 reads

Foreign Key Constraints Revisited

Full/partial schema refreshes across environments are a regular requirement in databases. This article builds on a previous article, providing scripts to disable and re-enable foreign key constraints on all of the tables in a schema.  Read more...
By Additional Articles 2009/08/05 | Source: Database Journal | Category: database design
Rating: (not yet rated)  Rate this |   Briefcase | 3,035 reads

Using SET NULL and SET DEFAULT with Foreign Key Constraints

Cascading Updates and Deletes, introduced with SQL Server 2000, were such an important, crucial feature that it is hard to imagine providing referential integrity without them. One of the new features in SQL Server 2005 that hasn't gotten a lot of press from what I've read is the new options for the ON DELETE and ON UPDATE clauses: SET NULL and SET DEFAULT. Let's take a look!  Read more...
By Additional Articles 2008/08/28 | Source: SQLTeam.com | Category: referential integrity
Rating:  Rate this |   Briefcase | 2,892 reads

Avoid Untrusted Constraints in SQL Server

Some time ago, I loaded a large set of data into one my tables. To speed up the load, I disabled the FOREIGN KEY and CHECK constraints on the table and then re-enabled them after the load was complete. I am now finding that some of the loaded data was referentially invalid. What happened?  Read more...
By Additional Articles 2008/07/18 | Source: MSSQLTips.com | Category: referential integrity
Rating:  Rate this |   Briefcase | 2,940 reads
   Items 1 to 5 of 5