Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Foreign Key and Primary Key

Author  Topic 

Putt2Eagle
Starting Member

1 Post

Posted - 2009-04-02 : 09:33:23
Can you set a relationship with a foreign key in one table in one database to a primary key in another table in a seperate database?
Using SQL 2005 or MySQL

heavymind
Posting Yak Master

115 Posts

Posted - 2009-04-02 : 10:00:37
definitely no in sql server. though you can use triggers instead

Thanks, Vadym
MCITP DBA 2005/2008
Chief DBA at http://www.db-staff.com
Go to Top of Page
   

- Advertisement -