| title | sys.fulltext_catalogs (Transact-SQL) | ||||
|---|---|---|---|---|---|
| description | sys.fulltext_catalogs contains a row for each full-text catalog. | ||||
| author | rwestMSFT | ||||
| ms.author | randolphwest | ||||
| ms.date | 07/09/2026 | ||||
| ms.service | sql | ||||
| ms.subservice | system-objects | ||||
| ms.topic | reference | ||||
| f1_keywords |
|
||||
| helpviewer_keywords |
|
||||
| dev_langs |
|
||||
| monikerRange | =azuresqldb-current || >=sql-server-2016 || >=sql-server-linux-2017 || =azuresqldb-mi-current || =fabric-sqldb |
[!INCLUDE SQL Server Azure SQL Database Azure SQL Managed Instance FabricSQLDB]
Contains a row for each full-text catalog.
Note
The following columns will be removed in a future release of [!INCLUDE ssNoVersion]: data_space_id, file_id, and path. Don't 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. Unique across the full-text catalogs in the database. |
name |
sysname | Name of the catalog. 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 = Default. False = Not default. |
is_accent_sensitivity_on |
bit | Accent-sensitivity setting of the catalog. True = Accent-sensitive. False = 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 isn't being imported. |
[!INCLUDE ssCatViewPerm]