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

Content with tag DRI Rss

   Items 1 to 2 of 2   
 

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,638 reads

Defining cascading referential integrity constraints in SQL Server

By using cascading referential integrity constraints, you can define the actions that SQL Server 2005 takes when a user tries to delete or update a key to which existing foreign keys point.  Read more...
By Additional Articles 2008/06/20 | Source: Builder.com | Category: dri
Rating: (not yet rated)  Rate this |   Briefcase | 2,215 reads
   Items 1 to 2 of 2   
 
Tags
constraints (1)    
database design (1)    
foreign keys (fk) (1)    
referential integrity (1)