Saturday, June 9, 2012

What is self referential intigrity in sql server?

A foreign key in one table refers to primary key of same table is known as self referential intigrity.

ex:

Create table emp(eno int primary key, ename varchar(50), Manager int references emp(empno).


No comments:

Post a Comment