sys.fulltext_catalogs (Transact-SQL)
Applies to: 
SQL 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 SQL Server: 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: 1 = The catalog is being imported. 2 = The catalog is not 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.
See Also
Catalog Views (Transact-SQL)
CREATE FULLTEXT CATALOG (Transact-SQL)
ALTER FULLTEXT CATALOG (Transact-SQL)
DROP FULLTEXT CATALOG (Transact-SQL)