Applies To: SQL Server 2014, SQL Server 2016 Preview
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.
Applies to: SQL Server (SQL Server 2008 through current version), SQL Database V12.
ID of the full-text catalog. Is unique across the full-text catalogs in the database.
Name of the catalog. Is unique within the database.
Name of the catalog directory in the file system.
The default full-text catalog.
True = Is default.
False = Is not default.
Accent-sensitivity setting of the catalog.
True = Is accent-sensitive.
False = Is not accent-sensitive.
Filegroup where this catalog was created.
File ID of the full-text file associated with the catalog.
ID of the database principal that owns the full-text catalog.
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.