• I understood what you were looking for, which is why I said that the script I linked to would be a starting point. If you use the script I linked to and the other system views I mention you can get the information you are looking for in one query. Something like:

    [font="Courier New"]SELECT

       RC.Constraint_Name AS FK_Constraint,

       RC.Constraint_Catalog AS FK_Database,

       RC.Constraint_Schema AS FK_Schema,

       CCU.Table_Name AS FK_Table,

       CCU.Column_Name AS FK_Column

    FROM

       information_schema.referential_constraints RC JOIN

       INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE CCU ON

           RC.CONSTRAINT_NAME = CCU.CONSTRAINT_NAME JOIN

       INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE CCU2 ON

           RC.UNIQUE_CONSTRAINT_NAME = CCU2.CONSTRAINT_NAME LEFT JOIN

       sys.columns C ON

           CCU.Column_Name = C.name AND

           CCU.Table_Name = OBJECT_NAME(C.OBJECT_ID) LEFT JOIN

       sys.index_columns IC ON

           C.OBJECT_ID = IC.OBJECT_ID AND

           C.column_id = IC.column_id LEFT JOIN

       sys.indexes I ON

           IC.OBJECT_ID = I.OBJECT_ID AND

           IC.index_Id = I.index_Id

    WHERE

       I.name IS NULL

    ORDER BY

       RC.Constraint_NAME  

       [/font]

    This is not perfected, but it does do what I think you want it to do. It will show any tables with Foreign Keys where any column of that foreign key does not have an index on it.