Home -> Usenet -> comp.databases.theory -> Re: Database Design Question - any suggestion?

Re: Database Design Question - any suggestion?

From: -CELKO- <jcelko212_at_earthlink.net>
Date: 9 Dec 2004 15:04:33 -0800
Message-ID: <1102633473.328524.24930_at_f14g2000cwb.googlegroups.com> 






My hueristic has been that



    
  
  1.   if the values of a  constraint are short and do not change often
(sex -- not likely to see a new one any time soon) then use a CHECK()
constraint,

  
  2.   if the values of a constraint are long and/or change often, then use
a REFERENCES constraint.

  
  3.   if you have a CREATE DOMAIN statement in your product, then use it
and the ALTER DOMAIN statement as needed.



Received on Fri Dec 10 2004 - 00:04:33 CET












Original text of this message