What is an Integrity Constraint ?

Integrity constraint is a rule that restricts values to a column in a table.
  • Interview Candidate
  • 1
  • 1657

Showing Answers 1 - 1 of 1 Answers

samiksc

  • Jan 19th, 2006
 

Integrity constraint restricts values of a column so that only meaningful values as per the business logic of the table be entered into the column.

Integrity constraints are of the following types:

  1. Not null
  2. Unique
  3. Primary Key
  4. Foreign Key (referential integrity)
  5. Check -- custom constraints e.g. check sal > 0, check joiningdate > date()

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions