Welcome to

SqlServer-QA.net

Sign in | Join | Help

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

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
INNER JOIN
    sys
.indexes i ON fti.unique_index_id = i.index_id AND fti.object_id = i.
object_id
Published Sunday, August 02, 2009 11:45 PM by SQL Master

Comments

# SQL Server Transact-SQL (SSQA.net) : TSQL to find the name of unique index that refers full text index

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

Here is the useful script that I have workd out (part of it obtained from Technet) in order to find the

Monday, August 03, 2009 2:06 AM by Other SQL Server Blogs around the Web
Anonymous comments are disabled