what is CHECK Constraint?

 Posted by Syedshakeer on 11/30/2009 | Category: Sql Server Interview questions | Views: 2766
Answer:

The CHECK constraint is used to limit the value range that can be placed in a column.

If you define a CHECK constraint on a single column it allows only certain values for this column.
If you define a CHECK constraint on a table it can limit the values in certain columns based on values in other columns in the row.


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response