Udostępnij za pośrednictwem


sys.fulltext_catalogs (Transact-SQL)

Contains a row for each full-text catalog.

[!UWAGA]

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.

Permissions

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.

Zobacz także

Odwołanie

Catalog Views (Transact-SQL)

CREATE FULLTEXT CATALOG (Transact-SQL)

ALTER FULLTEXT CATALOG (Transact-SQL)

DROP FULLTEXT CATALOG (Transact-SQL)