Adding Foreign Key to an existing SQL Table

Today I came across this and was having issue with adding Foreign Key to an existing Table so thought share this with community with aspiration that someone would get help of it.


ALTER TABLE [dbo].[REQUEST]
ADD CONSTRAINT FK_LineManager_ListCode FOREIGN KEY ([LineManager_Name])
REFERENCES [dbo].[MANAGER_LIST](ListCode);