Edit

Share via

sys.fulltext_indexes (Transact-SQL)

Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance

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.
index_version int Version of full-text filter and wordbreaker components that are used to populate and query this index. If you perform an in-place upgrade from SQL Server 2022 (16.x) and earlier versions to SQL Server 2025 (17.x) and later versions, existing indexes are assigned index_version = 1. This value is controlled by the FULLTEXT_INDEX_VERSION database scoped configuration option.

Applies to: SQL Server 2025 (17.x) and later versions.
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.
property_list_id int ID of the search property list that is associated with this full-text index. NULL indicates that no search property list is associated with the full-text index. To obtain more information about this search property list, use the sys.registered_search_property_lists catalog view.

Permissions

The visibility of the metadata in catalog views is limited to securables that a user either owns, or on which the user was granted some permission.

Examples

The following example uses a full-text index on the HumanResources.JobCandidate table of the AdventureWorks2025 sample database. The example returns the object ID of the table, the search property list ID, 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.

USE AdventureWorks2025;
GO

SELECT object_id,
       property_list_id,
       stoplist_id
FROM sys.fulltext_indexes
WHERE object_id = object_id('HumanResources.JobCandidate');

Related content

  • Last updated on