sql-server - SQL 更改 : add multiple FKs?

Question

From here

ALTER TABLE ORDERS
ADD FOREIGN KEY (customer_sid) REFERENCES CUSTOMER(SID); 

如何使用 SQL Server 添加多个键？是像下面这样的吗？ (我无法测试 ATM，不幸的是我无法测试查询，除非我通过代码运行它)

ALTER TABLE ORDERS
ADD FOREIGN KEY (customer_sid) REFERENCES CUSTOMER(SID), 
ADD FOREIGN KEY (customer_sid2) REFERENCES CUSTOMER(SID2);

或者是这样的

ALTER TABLE ORDERS
ADD FOREIGN KEY (customer_sid, customer_sid2) REFERENCES CUSTOMER(SID, SID2)

Answer 1

ALTER TABLE ORDERS
    ADD FOREIGN KEY (customer_sid) REFERENCES CUSTOMER(SID),
        FOREIGN KEY (customer_sid2) REFERENCES CUSTOMER(SID2),
        FOREIGN KEY (customer_sid3) REFERENCES CUSTOMER(SID3);