Post reply

Locate Foreign keys without Indexes

  • May 1, 2006 at 7:04 am

    #635078

    I'm working in SQL Server 2005.  I don't know if you are using an earlier version.  If you are the system tables/available functions may be different.

    Sorry I can't be of more help.

  • July 31, 2006 at 11:25 am

    #652436

    barry555's script is just a starting point, it does not consider foreign keys on multiple columns, or several relations between two tables, it will mostly give wrong results

    i found a better way to 'Generate Index for Foreign Keys' at sqlservercentral itself while searching

    http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=1079

    i will be analyzing this script and comparing results, at first read is seems that already existing indexes are also included in the output, which when executed will result in errors

    i needed a query editor With Intellisense, sqlprompt failed as it is functions very erratically, any suggessions

Viewing 2 posts - 16 through 16 (of 16 total)

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