ms sql一個表中,引用另外一張表的組合主鍵作為外鍵:
ALTER TABLE [dbo].[Quotation]
ADD CONSTRAINT [FK__Quotation__0000000000000003]
FOREIGN KEY([C_N],[C_S])
REFERENCES [dbo].[Customer]([Customer_Number],[Customer_Sequence])
View Code
ms sql一個表中,引用另外一張表的組合主鍵作為外鍵:
ALTER TABLE [dbo].[Quotation]
ADD CONSTRAINT [FK__Quotation__0000000000000003]
FOREIGN KEY([C_N],[C_S])
REFERENCES [dbo].[Customer]([Customer_Number],[Customer_Sequence])
View Code