Mr Developer
0
Q:

data type for foreign key


CREATE TABLE Orders
(

   
OrderID int NOT NULL,

   
OrderNumber int NOT NULL,

   
PersonID int,

   
PRIMARY KEY (OrderID),

   
CONSTRAINT FK_PersonOrder FOREIGN KEY (PersonID)

   
REFERENCES Persons(PersonID)

); 
0

Tags

New to Communities?

Join the community