sys.fulltext_indexes (Transact-SQL)

Contains a row per full-text index of a tabular object.

Column name	Data type	Description
object_id	int	ID of the object to which this full-text index belongs.
unique_index_id	int	ID of the corresponding unique, non-full-text index that is used to relate the full-text index to the rows.
fulltext_catalog_id	int	ID of the full-text catalog in which the full-text index resides.
is_enabled	bit	1 = Full-text index is currently enabled.
change_tracking_state	char(1)	State of change-tracking. M = Manual A = Auto O = Off
change_tracking_state_desc	nvarchar(60)	Description of the state of change-tracking. MANUAL AUTO OFF
has_crawl_completed	bit	Last crawl (population) that the full-text index has completed.
crawl_type	char(1)	Type of the current or last crawl. F = Full crawl I = Incremental, timestamp-based crawl U = Update crawl, based on notifications P = Full crawl is paused.
crawl_type_desc	nvarchar(60)	Description of the current or last crawl type. FULL_CRAWL INCREMENTAL_CRAWL UPDATE_CRAWL PAUSED_FULL_CRAWL
crawl_start_date	datetime	Start of the current or last crawl. NULL = None.
crawl_end_date	datetime	End of the current or last crawl. NULL = None.
incremental_timestamp	binary(8)	Timestamp value to use for the next incremental crawl. NULL = None.

See Also