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.

stoplist_id

int

ID of the stoplist that is associated with this full-text index.

data_space_id

int

Filegroup where this full-text index resides.

Permissions

In SQL Server 2005 and later versions, the visibility of the metadata in catalog views is limited to securables that a user either owns or on which the user has been granted some permission. For more information, see Metadata Visibility Configuration.

Examples

The following example uses a full-text index on the HumanResources.JobCandidate table of the AdventureWorks2008R2 sample database. The example returns the object ID of the table and the stoplist ID of the stoplist used by the full-text index.

Note

For the code example that creates this full-text index, see the "Examples" section of CREATE FULLTEXT INDEX (Transact-SQL).

USE AdventureWorks2008R2;
GO
SELECT object_id, stoplist_id FROM sys.fulltext_indexes
    where object_id = object_id('HumanResources.JobCandidate'); 
GO