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.
Send feedback about: