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?
>
Showing posts with label constratint. Show all posts
Showing posts with label constratint. Show all posts
Thursday, March 8, 2012
Check Constraint
Labels:
column-level,
constraint,
constratint,
database,
microsoft,
mysql,
oracle,
server,
sql,
table-level
Subscribe to:
Posts (Atom)