DECLARE @table nvarchar(100),
@fkName nvarchar(100),
@columnName nvarchar(100),
@index nvarchar(800)

\r\n

DECLARE missing_FkIndex_cursor CURSOR FOR SELECT
      t.name as TB_Name
      , fk.name as FK_Name
      , c.name as Column_Name
FROM sys.foreign_key_columns fkc
INNER JOIN sys.tables t ON t.object_id = fkc.parent_object_id
INNER JOIN sys.foreign_keys fk ON fk.parent_object_id =
fkc.parent_object_id
INNER JOIN sys.columns c ON c.object_id = fk.parent_object_id AND
c.column_id = fkc.parent_column_id
LEFT OUTER JOIN sys.index_columns indc ON indc.object_id = c.object_id AND
c.column_id = indc.column_id
LEFT OUTER JOIN sys.indexes ind ON ind.object_id = indc.object_id AND
ind.index_id = indc.index_id
WHERE fk.type = \'F\' AND ind.name is null

\r\n

OPEN missing_FkIndex_cursor;

\r\n

FETCH NEXT FROM missing_FkIndex_cursor
INTO @table, @fkName, @columnName

\r\n

WHILE @@FETCH_STATUS = 0
BEGIN
SET @index = \'CREATE INDEX IX_FK_\' + @fkName + \'_\' + @columnName + \' ON \' + @table + \' (\' + @columnName + \')\'
EXECUTE sp_executesql @index
PRINT @index

FETCH NEXT FROM missing_FkIndex_cursor
INTO @table, @fkName, @columnName
END
CLOSE missing_FkIndex_cursor;
DEALLOCATE missing_FkIndex_cursor;

Metaprogrammierung