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).
ex:
Create table emp(eno int primary key, ename varchar(50), Manager int references emp(empno).
No comments:
Post a Comment