• I assume he's talking about a variation on the following, which is what SQL Server will create for you, if you create your fks from a diagram for example (which is what I usually do.)

    Here the 2 table names are present, and just an incremental number for the FK counter.

    If you include field names, you could find yourself on the wrong side of 255 character limit.

    '[dbo].[Custodian_SubPortfolio_FK1]'

    '[dbo].[Custodian_SubPortfolio_FK2]'

    '[dbo].[Dimension_SubPortfolio_FK1]'

    '[dbo].[Dimension_SubPortfolio_FK2]'

    '[dbo].[Dimension_SubPortfolio_FK3]'

    '[dbo].[FK_LeadPortfolio_SubPortfolio]'

    '[dbo].[FK_SubPortfolio_FundManager]'

    '[dbo].[InvestmentManager_LeadPortfolio_FK1]'

    '[dbo].[LegalEntity_LeadPortfolio_FK1]'

    '[dbo].[Mandate_SubPortfolio_FK1]'

    '[dbo].[ProductManager_LeadPortfolio_FK1]'

    '[dbo].[ThirdPartyA_SubPortfolio_FK1]'

    '[dbo].[TransferAgency_LeadPortfolio_FK1]'