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 |
