SQL Server Performance

TSQL to find the name of unique index that refers full text index

Discussion in 'Other SQL Server Blogs around the Web' started by Anonymous, Aug 2, 2009.

  1. Anonymous New Member

    Here is the useful script that I have workd out (part of it obtained from Technet) in order to find the name of unique index that refers full text index SELECT OBJECT_NAME ( fti . object_id ) AS 'Table Name' , i . name AS 'Index Name' , c . name AS 'Column Name' FROM sys . fulltext_indexes fti INNER JOIN sys . index_columns ic ON ic . object_id = fti . object_id AND ic . index_id = fti . unique_index_id INNER JOIN sys . columns c ON c . object_id = ic . object_id AND c . column_id = ic . column_id...(<a href="http://sqlserver-qa.net/blogs/t-sql/archive/2009/08/02/5849.aspx">read more</a>)<img src="http://sqlserver-qa.net/aggbug.aspx?PostID=5849" width="1" height="1">

Share This Page