Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
SQL Server
Azure SQL Database
Azure SQL Managed Instance
SQL database in Microsoft Fabric
Contains a row for each full-text catalog.
Note
The following columns will be removed in a future release of SQL Server: 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. |
Permissions
The visibility of the metadata in catalog views is limited to securables that a user either owns, or on which the user was granted some permission.