Search code examples
sql-serversql-server-2005indexingfull-text-indexingfull-text-search

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?


Solution

  • 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]