Export (0) Print
Expand All

sys.fulltext_catalogs (Transact-SQL)

Contains a row for each full-text catalog.

Note 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.

Applies to: SQL Server (SQL Server 2008 through current version).

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.

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.

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

Community Additions

ADD
Show:
© 2014 Microsoft