怎么给联合主键设置外键啊 有表A(a1,a2,a3)其中(a1,a2)为主键 a1对应表B主键b1 a2对应表C主键c1 在GUI里面怎么设置外键啊 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 我正好有一个例子和你说的一样,请参考:CREATE TABLE [dbo].[ContractorMobileService]( [ContractorID] [int] NOT NULL, [MobileServiceID] [int] NOT NULL, [Charge] [money] NOT NULL, CONSTRAINT [PK_ContractorMobileService] PRIMARY KEY CLUSTERED ( [ContractorID] ASC, [MobileServiceID] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]GOALTER TABLE [dbo].[ContractorMobileService] WITH NOCHECK ADD CONSTRAINT [FK_ContractorMobileService_Contractor] FOREIGN KEY([ContractorID])REFERENCES [dbo].[Contractor] ([ID])GOALTER TABLE [dbo].[ContractorMobileService] CHECK CONSTRAINT [FK_ContractorMobileService_Contractor]GOALTER TABLE [dbo].[ContractorMobileService] WITH NOCHECK ADD CONSTRAINT [FK_ContractorMobileService_MobileService] FOREIGN KEY([MobileServiceID])REFERENCES [dbo].[MobileService] ([ID])GOALTER TABLE [dbo].[ContractorMobileService] CHECK CONSTRAINT [FK_ContractorMobileService_MobileService]GO 语句的我知道用references就行 可是可视化的操作可以做到么? GUI界面,先右键表B,表C,选择设计,然后选择表B字段b1设置主键,表C字段c1设置主键,然后保存关闭。右键表A,选择设计,按住shift然后选择a1,a2设置为联合主键,然后右键a1列,选择关系,添加后右面点击表和列规范,弹出界面,左边选择主键表主键列,右面选择本表字段a1即可。a2同样设置。 请教表关联问题! 这样的数据改如何处理? 存储过程创建 SQL Server 2005 连接服务器的问题 异地、定期、加密备份所有用户数据库? sql server 如何获得表结构详细信息 在线等 求一个算法 SQL 统计时间 卡号挂失的存储过程??? 数据库设计时碰到的问题.UP也有分. 日志增长的比较快 外键和默认约束
[ContractorID] [int] NOT NULL,
[MobileServiceID] [int] NOT NULL,
[Charge] [money] NOT NULL,
CONSTRAINT [PK_ContractorMobileService] PRIMARY KEY CLUSTERED
(
[ContractorID] ASC,
[MobileServiceID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]GOALTER TABLE [dbo].[ContractorMobileService] WITH NOCHECK ADD CONSTRAINT [FK_ContractorMobileService_Contractor] FOREIGN KEY([ContractorID])
REFERENCES [dbo].[Contractor] ([ID])
GOALTER TABLE [dbo].[ContractorMobileService] CHECK CONSTRAINT [FK_ContractorMobileService_Contractor]
GOALTER TABLE [dbo].[ContractorMobileService] WITH NOCHECK ADD CONSTRAINT [FK_ContractorMobileService_MobileService] FOREIGN KEY([MobileServiceID])
REFERENCES [dbo].[MobileService] ([ID])
GOALTER TABLE [dbo].[ContractorMobileService] CHECK CONSTRAINT [FK_ContractorMobileService_MobileService]
GO
右键表A,选择设计,按住shift然后选择a1,a2设置为联合主键,然后右键a1列,选择关系,添加后右面点击表和列规范,弹出界面,左边选择主键表主键列,右面选择本表字段a1即可。
a2同样设置。