1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
| SELECT o.name As Table_Name, o.type,
i.name as index_name,
c.name AS Column_Name,
i.is_primary_key,
i.is_unique ,
CAST((case when ftic.object_id iS NULL then 0 ELSE 1 END) AS bit) as is_fulltext
FROM sys.index_columns ic
INNER JOIN sys.objects o
ON ic.object_id = o.object_id
AND o.name = 'ProductReview'
LEFT OUTER JOIN sys.fulltext_index_columns ftic
ON ftic.object_id = ic.object_id
and ftic.column_id = ic.column_id
INNER JOIN sys.schemas s
ON s.schema_id = o.schema_id
INNER JOIN sys.indexes i
ON ic.object_id = i.object_id
AND ic.index_id = i.index_id
INNER JOIN sys.columns c
ON ic.column_id = c.column_id
AND o.object_id = c.object_id
WHERE o.type In ('U', 'V') |