SQL Server / Oracle / MS Access: CREATETABLEOrders ( OrderID intNOTNULLPRIMARYKEY, OrderNumber intNOTNULL, PersonID intFOREIGNKEYREFERENCESPersons(PersonID) ); To allow naming of aFOREIGN KEYconstraint, and for defining aFOREIGN KEYconstraint on multiple columns, use the following SQL syntax: ...
To allow naming of a FOREIGN KEY constraint, and for defining a FOREIGN KEY constraint on multiple columns, use the following SQL syntax:CREATE TABLE Orders ( OrderID int NOT NULL, OrderNumber int NOT NULL, PersonID int, PRIMARY KEY (OrderID), CONSTRAINT FK_PersonOrder FOREIGN KEY (Person...