SQL Server/T-SQL Tutorial/System Tables Views/sys.fulltext indexes

Материал из SQL эксперт
Перейти к: навигация, поиск

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

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)