create a foreign key many to one relationship sql
snippet in sql

create a foreign key many to one relationship sql

user9411


CREATE TABLE Orders
(

   
OrderID int NOT NULL PRIMARY KEY,

   
OrderNumber int NOT NULL,

   
PersonID int FOREIGN KEY REFERENCES Persons(PersonID)

);