Skip to content

sys-fulltext-indexes-transact-sql.md

Latest commit

 

History

History
74 lines (65 loc) · 5.08 KB

sys-fulltext-indexes-transact-sql.md

File metadata and controls

74 lines (65 loc) · 5.08 KB
title sys.fulltext_indexes (Transact-SQL)
description sys.fulltext_indexes (Transact-SQL)
author rwestMSFT
ms.author randolphwest
ms.reviewer mikeray
ms.date 06/10/2016
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.
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 (Transact-SQL) catalog view.

Permissions

[!INCLUDEssCatViewPerm]

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 (Transact-SQL).

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

See Also

sys.fulltext_index_fragments (Transact-SQL)
sys.fulltext_index_columns (Transact-SQL)
sys.fulltext_index_catalog_usages (Transact-SQL)
Object Catalog Views (Transact-SQL)
Catalog Views (Transact-SQL)
Create and Manage Full-Text Indexes
DROP FULLTEXT INDEX (Transact-SQL)
CREATE FULLTEXT INDEX (Transact-SQL)
ALTER FULLTEXT INDEX (Transact-SQL)