Hi,

I was trying to reply the Posts by David McKinney and chrs-513176 in the same thread.

Where he is talking about rare scenario of having mutiple foreign keys between Table1 and Table2.

For Example-

Table1

Column1 int not null Primary key

Column2 int not null Unique Key

Table2

Column1 int references table1.column1

Column2 int references table1.column1

Here we can not go with the naming the foreign key like

FK_Table2_Table1, becauase there are two keys. Name duplication will become the issue

Here we can follow names like

FK1_Table2_Table1

FK2_Table2_Table1

As a second option we can add column name(s) along with FK_Table2_Table1, but key name may become lengthy if the keys are composite.