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