列出SQL Server 2005中哪些列具有全文索引 [英] List which columns have a full-text index in SQL Server 2005

问题描述

如何列出我的数据库中所有具有全文索引的表/列？

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]


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

解决方案

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]

这篇关于列出SQL Server 2005中哪些列具有全文索引的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！