Updated: June 10, 2016
Contains a row for each full-text catalog.
|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.