Full-Text Catalog and Index Properties (Transact-SQL)
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.
Note
Only full-text properties that are useful in SQL Server 2008 are discussed here.
Property |
Description |
Function |
|---|---|---|
AccentSensitivity |
Accent-sensitivity setting. |
|
FullTextTypeColumn |
TYPE COLUMN in the table that holds the document type information of the column. |
|
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. |
|
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. |
|
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 |
See Also