Re: [SQL] Foreign Key between different databases

2001-04-11 Thread Cedar Cox
AFAIK, not easily. There was a post to the hackers list recently with code for a "database connector" function. Using this it may be possible to write your own referential integrity triggers that reference the other database.. maybe not. I didn't look much into the code. There might be someth

[SQL] Foreign Key between different databases

2001-04-10 Thread Stan van de Mortel
Hello, I've a table in a database and I want to create a column that is a foreign key to a table in an other database. When I try ...,foreign key (x) references otherdb.table(x) it says 'parse error at or near "."'. Is there an other way to create this kind of foreign key? Stan van de Mortel [[