Showing posts with label constratint. Show all posts
Showing posts with label constratint. Show all posts

Thursday, March 8, 2012

Check Constraint

What is the difference in table-level and column-level check constratint?
Any example?Sorry, I forgot had posted here before.
"Alan T" <alanNOSPAMpltse@.yahoo.com.au> wrote in message
news:%23Hf4Hd26HHA.4584@.TK2MSFTNGP03.phx.gbl...
> What is the difference in table-level and column-level check constratint?
> Any example?
>|||A table level constraint is a Primary Key, or a Foreign key.
A column level constraint could be as simple as NOT NULL, or a CHECK clause
(CHECK _col IN ('Y', 'N'))
"Alan T" <alanNOSPAMpltse@.yahoo.com.au> wrote in message
news:%23Hf4Hd26HHA.4584@.TK2MSFTNGP03.phx.gbl...
> What is the difference in table-level and column-level check constratint?
> Any example?
>