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

Content with tags Database Design, constraints Rss

   Items 1 to 3 of 3   
 

It's Not All About The Keys

By Andy Warren 2014/04/14 | Category: foreign key
Rating: (not yet rated) |  Discuss |   Briefcase | 2,111 reads

Constraints and the Test-Driven Database

Bad data always seems to appear when, and where, one least expects it. Sam explains the great value of a defensive approach based on constraints to any team that is developing an application in which the data has to be exactly right, and where bad data could cause consequential severe financial damage. It is perhaps better seen as creating a test-driven database.  Read more...
By Additional Articles 2012/01/09 | Source: SimpleTalk | Category: database design
Rating: (not yet rated)  Rate this |   Briefcase | 1,927 reads

Constraint Yourself!

In his first article for Simple-Talk, Joe Celko demystifies the use of Constraints, and points out that they are an intrinsic part of SQL and are a great way of ensuring that a business rule is done one way, one place, one time.  Read more...
By Additional Articles 2008/10/30 | Source: SimpleTalk | Category: database design
Rating:  Rate this |   Briefcase | 2,445 reads
   Items 1 to 3 of 3   
 
Tags
foreign key (1)