Create and Manage Full-Text Catalogs

  • Article

A full-text catalog is a virtual object that does not belong to any filegroup; it is a logical concept that refers to a group of full-text indexes.

In This Topic

  • Creating a Full-Text Catalog

  • Viewing the Properties of a Full-Text Catalog

  • Viewing the Properties of a Full-Text Catalog

  • Rebuilding All Full-Text Catalogs for a Database

  • Removing a Full-Text Catalog from a Database

Creating a Full-Text Catalog

To create a full-text catalog

  1. In Object Explorer, expand the server, expand Databases, and expand the database in which you want to create the full-text catalog.

  2. Expand Storage, and then right-click Full Text Catalogs.

  3. Select New Full-Text Catalog.

  4. In the New Full-Text Catalog dialog box, specify the information for the catalog that you are re-creating. For more information, see New Full-Text Catalog (General Page).

    Note

    Full-text catalog IDs begin at 00005 and are incremented by one for each new catalog created.

  5. Click OK.  

[TOP]

Viewing the Properties of a Full-Text Catalog

Transact-SQL functions such as FULLTEXTCATALOGPROPERTY can be used to obtain the value of various properties related to full-text indexing. This information is useful for administering and troubleshooting full-text search.

The following table lists the properties that are related to full-text catalogs.

Property

Description

Function

AccentSensitivity

Accent-sensitivity setting.

FULLTEXTCATALOGPROPERTY

ImportStatus

Whether the full-text catalog is being imported.

FULLTEXTCATALOGPROPERTY

IndexSize

Size of the full-text catalog in megabytes (MB).

FULLTEXTCATALOGPROPERTY

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

UniqueKeyCount

Number of unique keys in the full-text catalog.

FULLTEXTCATALOGPROPERTY

[TOP]

Rebuilding a Full-Text Catalog

To rebuild a full-text catalog

  1. In Object Explorer, expand the server, expand Databases, and then expand the database that contains the full-text catalog that you want to rebuild.

  2. Expand Storage, and then expand Full Text Catalogs.

  3. Right-click the name of the full-text catalog that you want to rebuild, and select Rebuild.

  4. To the question Do you want to delete the full-text catalog and rebuild it?, click OK.

  5. In the Rebuild Full-Text Catalog dialog box, click Close.

[TOP]

Rebuilding All Full-Text Catalogs for a Database

To rebuild the full-text catalogs for a database

  1. In Object Explorer, expand the server, expand Databases, and then expand the database that contains the full-text catalogs that you want to rebuild.

  2. Expand Storage, and then right-click Full Text Catalogs.

  3. Select Rebuild All.

  4. To the question, Do you want to delete all full-text catalogs and rebuild them?, click OK.

  5. In the Rebuild All Full-Text Catalogs dialog box, click Close.

[TOP]

Removing a Full-Text Catalog from a Database

To remove a full-text catalog from a database

  1. In Object Explorer, expand the server, expand Databases, and expand the database that contains the full-text catalog you want to remove.

  2. Expand Storage, and expand Full Text Catalogs.

  3. Right-click the full-text catalog that you want to remove, and then select Delete.

  4. In the Delete Objects dialog box, click OK.

[TOP]

See Also

Reference

CREATE FULLTEXT CATALOG (Transact-SQL)