.png)
Create and Manage Full-Text Catalogs
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.
To create a full-text catalog
-
In Object Explorer, expand the server, expand Databases, and expand the database in which you want to create the full-text catalog.
-
Expand Storage, and then right-click Full Text Catalogs.
-
Select New Full-Text Catalog.
-
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.
-
Click OK.
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. |
|
|
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 |
To rebuild a full-text catalog
-
In Object Explorer, expand the server, expand Databases, and then expand the database that contains the full-text catalog that you want to rebuild.
-
Expand Storage, and then expand Full Text Catalogs.
-
Right-click the name of the full-text catalog that you want to rebuild, and select Rebuild.
-
To the question Do you want to delete the full-text catalog and rebuild it?, click OK.
-
In the Rebuild Full-Text Catalog dialog box, click Close.
To rebuild the full-text catalogs for a database
-
In Object Explorer, expand the server, expand Databases, and then expand the database that contains the full-text catalogs that you want to rebuild.
-
Expand Storage, and then right-click Full Text Catalogs.
-
Select Rebuild All.
-
To the question, Do you want to delete all full-text catalogs and rebuild them?, click OK.
-
In the Rebuild All Full-Text Catalogs dialog box, click Close.
To remove a full-text catalog from a database
-
In Object Explorer, expand the server, expand Databases, and expand the database that contains the full-text catalog you want to remove.
-
Expand Storage, and expand Full Text Catalogs.
-
Right-click the full-text catalog that you want to remove, and then select Delete.
-
In the Delete Objects dialog box, click OK.
