What is check constraint?

Answer Posted / rajeev

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.

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is flush privileges in mysql?

520


How can we change the data type of a column of a table?

582


How can you see all indexes defined for a table?

617


How to update a root password.

531


What do you need to connect php to mysql?

524






What are the advantages of a procedure?

468


What is trigger in mysql?

488


What is the query to display top 20 rows?

603


What is orm in mysql?

473


How to calculate the difference between two time values?

453


Is number a datatype in mysql?

484


How do I tune a mysql query?

470


What is 'mysqlshow'?

636


What are the types of database engines available in mysql?

471


Where is the myisam table stored?

526