Show suggestions for missing table indexes in SQL Server.

select
    object_name(fk.constraint_object_id) as constraint_name,
    object_name(fk.parent_object_id) as table_name,
    cl.name
from sys.foreign_key_columns as fk
inner join sys.columns as cl
    on fk.parent_object_id = cl.object_id
    and fk.parent_column_id = cl.column_id
left outer join sys.index_columns as c
on fk.parent_object_id = c.object_id
    and fk.parent_column_id = c.column_id
where c.object_id is null
order by
    table_name, fk.constraint_column_id;