使用CREATE TABLE语句的定义中定义两个外键引用:
USE AdventureWorks
GO
CREATE TABLE Person.EmployeeCreditRating
(
EmployeeCreditRating int NOT NULL PRIMARY KEY,
ContactID int NOT NULL,
CreditRatingID int NOT NULL,
CONSTRAINT FK_EmployeeCreditRating_Employee
FOREIGN KEY (ContactID)
REFERENCES HumanResources.Employee(EmployeeID),
CONSTRAINT FK_EmployeeCreditRating_CreditRating
FOREIGN KEY (CreditRatingID)
REFERENCES Person.CreditRating(CreditRatingID)
代码的前4行定义了表名和它的3个列:
接下来的一行定义了第一个外键约束名(必须是当前数据库中的唯一名):
之后定义了约束类型,后限表的列(它会引用外部的主键表):}
定义引用的表,并在圆括号中定义表的主键列:
然后为CreditRatingID列创建第二个外键,它引用Person.CreditRating表的主键: