Cross Database Foreign key

I have two database Named DB1 and DB2

In db1 i have created a table

create table db1.dbo.dept (deptid int primary key,deptname nvarchar(50) not null)

In db2 I want to create a table

create table db2.dbo.employee (employeeid int primary key,

deptid int foreign key references db1.dbo.dept(deptid))

It gives the error Cross database foreign key not supported

I want to create cross database foreign key and enforce the constraint against insert,update and delete

 

Can be done by creating database links , I haven't tried but have a concept and I think it should work More details @ http://www.dba-oracle.com/t_create_database_link_oracle.htm -Gaurav +91-986-888-0002