dimanche 24 juillet 2016

Check constraint vs proper lookup table

I need to use sets in standard SQL. I need describe column type like selection from set of something (Example Color=[Red, Green, Blue] ). I can use check constrain or create lookup table with tree records - Red,Green,Blue. What are pluses and minuses of each method. I need to make this solution universal and use in much as possible SQL servers.

Aucun commentaire:

Enregistrer un commentaire