Several Transact-SQL functions such as OBJECTPROPERTYEX and FULLTEXTCATALOGPROPERTY can be used to obtain the value of various full-text indexing properties. This information is useful for administrating and troubleshooting full-text search.
The following table lists available full-text properties and their related Transact-SQL functions.
|
Property
|
Description
|
Function
|
|---|
|
AccentSensitivity
|
Accent-sensitivity setting.
|
FULLTEXTCATALOGPROPERTY
|
|
FullTextTypeColumn
|
TYPE COLUMN in the table that holds the document type information of the column.
|
COLUMNPROPERTY
|
|
ImportStatus
|
Whether the full-text catalog is being imported.
|
FULLTEXTCATALOGPROPERTY
|
|
IndexSize
|
Size of the full-text catalog in megabytes (MB).
|
FULLTEXTCATALOGPROPERTY
|
|
|
|
|
|
IsFulltextIndexed
|
Whether a column has been enabled for full-text indexing.
|
COLUMNPROPERTY
|
|
IsFulltextKey
|
Whether the index is the full-text key for a table.
|
INDEXPROPERTY
|
|
ItemCount
|
Number of full-text indexed items currently in the full-text catalog.
|
FULLTEXTCATALOGPROPERTY
|
|
|
|
|
|
MergeStatus
|
Whether a master merge is in progress.
|
FULLTEXTCATALOGPROPERTY
|
|
PopulateCompletionAge
|
Difference in seconds between the completion of the last full-text index population and 01/01/1990 00:00:00.
|
FULLTEXTCATALOGPROPERTY
|
|
PopulateStatus
|
Populate status.
This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
|
FULLTEXTCATALOGPROPERTY
|
|
TableFulltextBackgroundUpdateIndexOn
|
Whether a table has full-text background update indexing.
|
OBJECTPROPERTYEX
|
|
TableFulltextCatalogId
|
Full-text catalog ID in which the full-text index data for the table resides.
|
OBJECTPROPERTYEX
|
|
TableFulltextChangeTrackingOn
|
Whether a table has full-text change-tracking enabled.
|
OBJECTPROPERTYEX
|
|
TableFulltextDocsProcessed
|
Number of rows processed since the start of full-text indexing.
|
OBJECTPROPERTYEX
|
|
TableFulltextFailCount
|
Number of rows Full-Text Search did not index.
|
OBJECTPROPERTYEX
|
|
TableFulltextItemCount
|
Number of rows that were successfully full-text indexed.
|
OBJECTPROPERTYEX
|
|
TableFulltextKeyColumn
|
The column ID of the full-text unique key column.
|
OBJECTPROPERTYEX
|
|
TableFullTextMergeStatus
|
Whether a table that has a full-text index is currently in merging.
|
OBJECTPROPERTYEX
|
|
TableFulltextPendingChanges
|
Number of pending change tracking entries to process.
|
OBJECTPROPERTYEX
|
|
TableFulltextPopulateStatus
|
Population status of a full-text table.
|
OBJECTPROPERTYEX
|
|
TableHasActiveFulltextIndex
|
Whether a table has an active full-text index.
|
OBJECTPROPERTYEX
|
|
UniqueKeyCount
|
Number of unique keys in the full-text catalog.
|
FULLTEXTCATALOGPROPERTY
|