English 中文(简体)
2008年8月8日SQ库两个数据库之间的外国关键关系船
原标题:Foreign key relation ship between two databases in SQL Server 2008

我有两个数据库,能否在2008年K.服务器不同数据库的两个表格之间建立一个外国钥匙?

thanks

最佳回答

From Books Online:

A FOREIGN KEY constraint can reference columns in tables in the same database or within the same table.

因此,你不能在不同数据库的两个表格之间造成外国的关键限制。

这是使用多个数据库的一个缺点。

问题回答

如果你使用Linq2Sql或实体框架,你可以在设计人中这样做。

但正如我能说的那样,在非行本身,你可以这样做。





相关问题
Anyone feel like passing it forward?

I m the only developer in my company, and am getting along well as an autodidact, but I know I m missing out on the education one gets from working with and having code reviewed by more senior devs. ...

How to Add script codes before the </body> tag ASP.NET

Heres the problem, In Masterpage, the google analytics code were pasted before the end of body tag. In ASPX page, I need to generate a script (google addItem tracker) using codebehind ClientScript ...

Transaction handling with TransactionScope

I am implementing Transaction using TransactionScope with the help this MSDN article http://msdn.microsoft.com/en-us/library/system.transactions.transactionscope.aspx I just want to confirm that is ...

System.Web.Mvc.Controller Initialize

i have the following base controller... public class BaseController : Controller { protected override void Initialize(System.Web.Routing.RequestContext requestContext) { if (...

Microsoft.Contracts namespace

For what it is necessary Microsoft.Contracts namespace in asp.net? I mean, in what cases I could write using Microsoft.Contracts;?

Separator line in ASP.NET

I d like to add a simple separator line in an aspx web form. Does anyone know how? It sounds easy enough, but still I can t manage to find how to do it.. 10x!

热门标签