Foreign Key

Image


ALTER TABLE ChildTable
ADD CONSTRAINT LoremIpsum
FOREIGN KEY (ChildColumn) REFERENCES ParentTable (ParentColumn)


ALTER TABLE [dbo].[UserProducts]
ADD CONSTRAINT [FK_UserProducts_Users]
FOREIGN KEY (UserID) REFERENCES [dbo].[Users](UserID)