Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

List which columns have a full-text index in SQL Server 2005

How do I list all tables / columns in my database that have a full-text index?

like image 993
Andreas Ågren Avatar asked Jun 04 '09 09:06

Andreas Ågren


1 Answers

select distinct
    object_name(fic.[object_id]) table_name,
    [name] column_name
from
    sys.fulltext_index_columns fic
    inner join sys.columns c
        on c.[object_id] = fic.[object_id]
        and c.[column_id] = fic.[column_id]
like image 124
Andreas Ågren Avatar answered Oct 30 '22 17:10

Andreas Ågren