Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Articles with tag Referential Integrity Rss

Search for any content tagged referential integrity

   Items 1 to 4 of 4   
 

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,657 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 | 2,622 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,455 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,681 reads
   Items 1 to 4 of 4