What is self-referential integrity constraint ?

If a foreign key reference a parent key of the same table is called self-referential integrity constraint.

Showing Answers 1 - 1 of 1 Answers

samiksc

  • Jan 19th, 2006
 

Self referential integrity constraint refers to two columns related by referential integrity which belong to the same table.

For example ManagerId column in employees table is a foreign key which refers to EmployeeId in the same table.

  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.

Answer Question

Click here to Login / Register your free account


 
Send   Reset

 

Related Answered Questions

 

Related Open Questions