Post reply

The Ultimate Index-Less Foreign-Key Finder

  • October 4, 2009 at 10:04 am

    #385499

    Comments posted to this topic are about the item The Ultimate Index-Less Foreign-Key Finder

  • October 15, 2009 at 9:27 am

    #1066344

    Nice script.

    Might this

    'CREATE NONCLUSTERED INDEX IX__' + parentschemas.name + '_' + parentobjects.name + '__' + REPLACE(foreign_key_columns.foreign_key_columns, ', ', '_') + ' ON ' + parentschemas.name + '.' + parentobjects.name + ' (' + foreign_key_columns.foreign_key_columns + ')' AS FKIndexCreate

    be this

    'CREATE NONCLUSTERED INDEX IX__' + parentschemas.name + '_' + parentobjects.name + '__' + REPLACE(foreign_key_columns.foreign_key_columns, ',', '') + ' ON ' + parentschemas.name + '.' + parentobjects.name + ' (' + REPLACE( foreign_key_columns.foreign_key_columns, ',', '' ) + ')' AS FKIndexCreate

    Great Job, As Usual,

    Doug

  • May 23, 2016 at 4:55 pm

    #1880925

    Thanks for the script.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply