如何在 sql server management studio 2012 中创建复合外键 [英] How to create composite foreign key in sql server management studio 2012
问题描述
我可以通过选择两列(OrderId、CompanyId)并右键单击并设置为主键,在 sql server management studio 2012 中成功创建复合主键.但我不知道如何使用 sql server management studio 2012 在其他表中的两列(OrderId、CompanyId)上创建外键.
I can successfully create composite primary key in sql server management studio 2012 by selecting two columns (OrderId, CompanyId) and right click and set as primary key. But i don't know how to create foreign key on two columns(OrderId, CompanyId) in other table by using sql server management studio 2012.
推荐答案
在对象资源管理器中,转到您的表并选择 Keys >上下文菜单中的新外键
:
In Object Explorer, go to your table and select Keys > New Foreign Key
from the context menu:
在弹出的对话框中,点击Add按钮来创建一个新的外键:
From the dialog box that pops up, click on the Add button to create a new foreign key:
给它一个有意义的名字,然后点击...按钮打开Tables and Columns Specification
对话框:
Give it a meaningful name and then click on the ... button to open the Tables and Columns specification
dialog box:
为父表和子表填写必要的列,点击确定,大功告成!
Fill in the necessary columns for the parent and the child tables, click OK and you're done!
或者更简单、更高效 - 使用 T-SQL 脚本!
Or much easier and more efficiently - use a T-SQL script!
ALTER TABLE dbo.OtherTable
ADD CONSTRAINT FK_OtherTable_ParentTable
FOREIGN KEY(OrderId, CompanyId) REFERENCES dbo.ParentTable(OrderId, CompanyId)
这篇关于如何在 sql server management studio 2012 中创建复合外键的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!