Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

sys.fulltext_catalogs (Transact-SQL)

Applies To: SQL Server 2014, SQL Server 2016 Preview

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

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), SQL Database V12.

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.

Community Additions

ADD
Show:
© 2015 Microsoft