| title | sys.fulltext_indexes (Transact-SQL) | Microsoft Docs | ||||
|---|---|---|---|---|---|
| ms.custom | |||||
| ms.date | 06/10/2016 | ||||
| ms.prod | sql | ||||
| ms.prod_service | database-engine, sql-database | ||||
| ms.technology | system-objects | ||||
| ms.topic | language-reference | ||||
| f1_keywords |
|
||||
| dev_langs |
|
||||
| helpviewer_keywords |
|
||||
| ms.assetid | 7fc10fdc-370f-4927-bba0-b76108a7508e | ||||
| author | pmasl | ||||
| ms.author | pelopes | ||||
| ms.reviewer | mikeray | ||||
| monikerRange | =azuresqldb-current||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current |
[!INCLUDE SQL Server SQL Database]
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. |
[!INCLUDEssCatViewPerm]
The following example uses a full-text index on the HumanResources.JobCandidate table of the AdventureWorks2012 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 AdventureWorks2012;
GO
SELECT object_id, property_list_id, stoplist_id FROM sys.fulltext_indexes
where object_id = object_id('HumanResources.JobCandidate');
GO
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)