Export (0) Print
Expand All
Expand Minimize

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft