FULLTEXTCATALOGPROPERTY

Returns information about full-text catalog properties.

Syntax

FULLTEXTCATALOGPROPERTY ('catalog_name' ,'property')

Arguments

catalog_name

Is an expression containing the name of the full-text catalog.

property

Is an expression containing the name of the full-text catalog property. The table lists the properties and provides descriptions of the information returned.

Property Description
AccentSensitivity Accent=sensitivity setting. 0 = Accent insensitive
IndexSize Logical size of the full=text catalog in megabytes (MB). Includes the size of semantic key phrase and document similarity indexes. Returns 0.
ItemCount Number of indexed items including all full=text, keyphrase and document similarity indexes in a catalog. Returns 0.
LogSize Supported for backward compatibility only. Always returns 0.
MergeStatus Whether a master merge is in progress. 0 = master merge not in progress
PopulateCompletionAge The difference in seconds between the completion of the last full=text index population and 01/01/1990 00:00:00. Returns 0. Only updated for full and incremental crawls. Returns 0 if no population has occurred.
PopulateStatus 0 = Idle
UniqueKeyCount Number of unique keys in the full=text catalog. Returns 0.
ImportStatus Whether the full=text catalog is being imported. 0 = The full=text catalog is not being imported.

Return types

int

Example

SELECT FULLTEXTCATALOGPROPERTY('Cat_Desc', 'ItemCount');

See Also