Skip to content

sys-fulltext-indexes-transact-sql.md

Latest commit

 

History

History
80 lines (68 loc) · 5.31 KB

sys-fulltext-indexes-transact-sql.md

File metadata and controls

80 lines (68 loc) · 5.31 KB
title sys.fulltext_indexes (Transact-SQL)
description sys.fulltext_indexes contains a row per full-text index of a tabular object.
author rwestMSFT
ms.author randolphwest
ms.reviewer mikeray
ms.date 12/01/2025
ms.service sql
ms.subservice system-objects
ms.topic reference
f1_keywords
fulltext_indexes
fulltext_indexes_TSQL
sys.fulltext_indexes_TSQL
sys.fulltext_indexes
helpviewer_keywords
sys.fulltext_indexes catalog view
full-text indexes [SQL Server], properties
dev_langs
TSQL
monikerRange =azuresqldb-current || >=sql-server-2016 || >=sql-server-linux-2017 || =azuresqldb-mi-current

sys.fulltext_indexes (Transact-SQL)

[!INCLUDE 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 [!INCLUDE sql-server-2022] and earlier versions to [!INCLUDE sql-server-2025] 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: [!INCLUDE sql-server-2025] 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

[!INCLUDE ssCatViewPerm]

Examples

The following example uses a full-text index on the HumanResources.JobCandidate table of the [!INCLUDE sssampledbobject-md] 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