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

Content with tag Referential Integrity Rss

   Items 1 to 9 of 9   
 

SQL

By Samith C 2012/11/30 | Category: referential integrity
Rating: (not yet rated) |  Discuss |   Briefcase | 2,311 reads

Changing Primary key names to standard naming convention across the DB

This script will rename the Primary keys to standard notation - PK_TableName  Read more...
By Vidyadhar Pandekar 2011/07/29 | Source: SQLServerCentral.com | Category: rename primary key
Rating: |  Discuss |   Briefcase | 1,636 reads

Case and Padding FK Relationship Tester

Tests the referential integrity of a db when taking into consideration padding and case sensitivity.  Read more...
By Cameron Wells 2011/07/26 | Source: SQLServerCentral.com | Category: referential integrity
Rating: |  Discuss |   Briefcase | 429 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,658 reads

Changing Primary key names to standard naming convention across the DB

This script will rename the Primary keys to standard notation - PK_TableName  Read more...
By Vidyadhar Pandekar 2011/07/29 | Source: SQLServerCentral.com | Category: rename primary key
Rating: |  Discuss |   Briefcase | 1,636 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,628 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,460 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,684 reads

Change column type on constrained columns

Use this proc if you need to alter a column that is part of a primery key  Read more...
By Luiz Barros 2008/02/04 | Source: SQLServerCentral.com | Category: referential integrity
Rating: |  Discuss |   Briefcase | 1,076 reads
   Items 1 to 9 of 9   
 
Tags
constraints (1)    
data integrity (1)    
database design (1)    
dri (1)    
foreign keys (fk) (1)    
primary key (pk) (1)    
rename primary key (1)    
sql server (1)    
t-sql (1)