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');