Export (0) Print
Expand All

sys.fulltext_catalogs (Transact-SQL)

Contains a row for each full-text catalog.

NoteNote

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.

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft