sys.fulltext_catalogs (Transact-SQL)
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. |