REFRENTIAL INTEGRITY CONSTRAINT ON TABLE IN OTHER SCHEMA 2

[culshaja]

How do I put a referential integrity constraint on a table, with the reference being to a key on a table in another schema?<br>
I tried using views but it dosn't allow me to do this as it says it can't resolve the object.<br>
<br>
james

 

[carp]

First, you need to either create a synonym for the table or fully qualify the table name with the schema.table_name.<br>
Secondly, you need &quot;REFERENCES&quot; privileges on the table.

 

[culshaja]

I forgot the references privilige. I have a public synonym on a view that I want to reference so I had remembered that.<br>
<br>
Thanks for your help,<br>
<br>
James