SqlDataComparison_Gist2.sql

SELECT c.column_id, c.name
FROM sys.objects o
INNER JOIN sys.schemas s
ON o.schema_id = s.schema_id
AND s.name = @schema_name
INNER JOIN sys.indexes i
ON o.object_id = i.object_id
AND i.is_primary_key = 1
INNER JOIN sys.index_columns ic
ON i.object_id = ic.object_id
AND i.index_id = ic.index_id
INNER JOIN sys.columns c
ON c.column_id = ic.column_id
AND c.object_id = o.object_id
WHERE o.name = @table_name