The Ultimate Index-Less Foreign-Key Finder

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Jesse Roberge » The Ultimate Index-Less Foreign-Key Finder

The Ultimate Index-Less Foreign-Key Finder

Rate Topic

Display Mode

Topic Options

Author

Message

YeshuaAgapao

Posted Sunday, October 04, 2009 10:04 AM

Say Hey Kid

Group: General Forum Members
Last Login: Wednesday, May 01, 2013 5:17 PM
Points: 701, Visits: 207

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

Post #797562

Douglas Osborne-456728

Posted Thursday, October 15, 2009 9:27 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, January 26, 2011 1:32 PM
Points: 146, Visits: 327

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

Post #803542

« Prev Topic | Next Topic »

Permissions