Re: foreign key constraints between tables in different databases
From: Tom Moreau (tom_at_dont.spam.me.cips.ca)
Date: 02/16/04
- Next message: Bob: "Re: foreign key constraints between tables in different databases"
- Previous message: Jesus Giraut: "How to Rebuild a View in SQL 2000?"
- In reply to: Bob: "foreign key constraints between tables in different databases"
- Next in thread: Bob: "Re: foreign key constraints between tables in different databases"
- Reply: Bob: "Re: foreign key constraints between tables in different databases"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 16 Feb 2004 16:46:40 -0500
No, you can use triggers, however:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/htm
l/sql_refintegrity.asp
-- Tom --------------------------------------------------------------- Thomas A. Moreau, BSc, PhD, MCSE, MCDBA SQL Server MVP Columnist, SQL Server Professional Toronto, ON Canada www.pinnaclepublishing.com/sql "Bob" <noemail@nospam.net> wrote in message news:uRaEuVN9DHA.2316@TK2MSFTNGP11.phx.gbl... Is is possible to have foreign key constraints between tables in different databases? Bob
- Next message: Bob: "Re: foreign key constraints between tables in different databases"
- Previous message: Jesus Giraut: "How to Rebuild a View in SQL 2000?"
- In reply to: Bob: "foreign key constraints between tables in different databases"
- Next in thread: Bob: "Re: foreign key constraints between tables in different databases"
- Reply: Bob: "Re: foreign key constraints between tables in different databases"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|