The sys.fulltext_indexes system catalog view lists all full-text indexes in the database. : sys.fulltext_indexes « System Tables Views « SQL Server / T-SQL Tutorial






3>
4> SELECT object_name(object_id) table_name, change_tracking_state_desc
5> FROM sys.fulltext_indexes
6> GO
table_name
         change_tracking_state_desc
------------------------------------------------------------------------------------------------------------------------
-------- ------------------------------------------------------------

(0 rows affected)








27.6.sys.fulltext_indexes
27.6.1.The sys.fulltext_indexes system catalog view lists all full-text indexes in the database.