Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Content with tag DRI Rss

   Items 1 to 3 of 3   

The DRI Subject of References

A database must be able to maintain and enforce the business rules and relationships in data in order to maintain the data model. It does this through referential constraints. They aren't complex, but are powerful, especially with the means to attach DRI actions to them. Joe Celko explains all, and pines for the ANSI CREATE ASSERTION statement.  Read more...
By Additional Articles 2015/02/25 | Source: SimpleTalk | Category: dri
Rating:  Rate this |   Briefcase | 8,576 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,756 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: | Category: dri
Rating: (not yet rated)  Rate this |   Briefcase | 2,301 reads
   Items 1 to 3 of 3   
constraints (1)    
database design (1)    
foreign keys (fk) (1)    
referential integrity (1)