sys.fulltext_catalogs (Transact-SQL)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Contains a row for each full-text catalog.


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.


The visibility of the metadata in catalog views is limited to securables that a user either owns or on which the user has been granted some permission.

See Also

Catalog Views (Transact-SQL)