| title | sys.fulltext_catalogs (Transact-SQL) | ||||
|---|---|---|---|---|---|
| description | sys.fulltext_catalogs (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 |
|
||||
| helpviewer_keywords |
|
||||
| dev_langs |
|
[!INCLUDESQL Server Azure SQL Managed Instance]
Contains a row for each full-text catalog.
Note
The following columns will be removed in a future release of [!INCLUDEssNoVersion]: data_space_id, file_id, and path. Do not use these columns in new development work, and modify applications that currently use any of these columns as soon as possible.
| Column name | Data type | Description |
|---|---|---|
| fulltext_catalog_id | int | ID of the full-text catalog. Is unique across the full-text catalogs in the database. |
| name | sysname | Name of the catalog. Is unique within the database. |
| path | nvarchar(260) | Name of the catalog directory in the file system. |
| is_default | bit | The default full-text catalog. True = Is default. False = Is not default. |
| is_accent_sensitivity_on | bit | Accent-sensitivity setting of the catalog. True = Is accent-sensitive. False = Is not accent-sensitive. |
| data_space_id | int | Filegroup where this catalog was created. |
| file_id | int | File ID of the full-text file associated with the catalog. |
| principal_id | int | ID of the database principal that owns the full-text catalog. |
| is_importing | bit | Indicates whether the full-text catalog is being imported: 0 = The catalog is being imported. 1 = The catalog is not being imported. |
[!INCLUDEssCatViewPerm]
Catalog Views (Transact-SQL)
CREATE FULLTEXT CATALOG (Transact-SQL)
ALTER FULLTEXT CATALOG (Transact-SQL)
DROP FULLTEXT CATALOG (Transact-SQL)