Export (0) Print
Expand All

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.

Community Additions

ADD
Show:
© 2014 Microsoft