sys.fulltext_catalogs (Transact-SQL)
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
In SQL Server 2005 and later versions, 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. For more information, see Metadata Visibility Configuration.