Export (0) Print
Expand All

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.

NoteNote

Only full-text properties that are useful in SQL Server 2008 are discussed here.

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

Community Additions

ADD
Show:
© 2014 Microsoft