查询与全文索引相关的内部元数据sql语句

select
SCHEMA_NAME(t.schema_id) as user_table_schema,
OBJECT_NAME(fti.object_id) as user_table,
fti.object_id as user_table_name,
it.name as internal_table_name,
it.object_id as internal_table_id,
it.internal_type_desc
from sys.internal_tables as it

inner join sys.fulltext_indexes as fti
ON it.parent_id=fti.object_id
inner join sys.tables t
on t.object_id=fti.object_id
where it.internal_type_desc like '%FULLTEXT%'

ORDER BY USER_TABLE;

原文地址:https://www.cnblogs.com/hbhzz/p/3490550.html