| title | description | author | ms.author | ms.reviewer | ms.date | ms.service | ms.subservice | ms.topic | f1_keywords | helpviewer_keywords | dev_langs | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
sys.fulltext_catalogs (Transact-SQL) |
sys.fulltext_catalogs (Transact-SQL) |
rwestMSFT |
randolphwest |
mikeray |
06/10/2016 |
sql |
system-objects |
reference |
|
|
|
[!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)