Home Forums Article Discussions Article Discussions by Author Discuss content posted by Martin Collazos List Table Foreign Keys, Primary key and indexes RE: List Table Foreign Keys, Primary key and indexes
m mcdonald
Hall of Fame
Points: 3264
More actions
February 18, 2014 at 12:46 pm
#1690025
For the index query try
INNER JOIN sys.index_columns b
ON a.[object_id] = b.[object_id] and a.index_id = b.index_id