FullTextCatalog Object

后续版本的 Microsoft SQL Server 将删除该功能。请避免在新的开发工作中使用该功能，并着手修改当前还在使用该功能的应用程序。

The FullTextCatalog object exposes the properties of a single Microsoft Search persistent data store.

Properties

ErrorLogSize Property	PopulateCompletionAge Property
FullTextCatalogID Property	PopulateCompletionDate Property
FullTextIndexSize Property	PopulateStatus Property
HasFullTextIndexedTables Property	RootPath Property
ItemCount Property	UniqueKeyCount Property
Name Property

Methods

GenerateSQL Method (FullTextCatalog)	Script Method
Rebuild Method	Start Method (FullTextCatalog)
Remove Method (Objects)	Stop Method

备注

Microsoft Search enables full-text queries on data maintained by Microsoft SQL Server. The service builds both the indexes providing full-text query capability and participates in query resolution by providing result data during a full-text query. Index data is maintained within a full-text catalog. A FullTextCatalog object exposes the properties of a Microsoft Search full-text catalog.

With the FullTextCatalog object, you can:

• Define a new Microsoft Search full-text catalog.
• Rebuild the Microsoft Search full-text catalog.
• Control index population.
• Remove a Microsoft Search full-text catalog.

The Name property of a FullTextCatalog object uses the SQL Server data type sysname. The value of the Name property must be unique within a SQL Server database.

By default, a user must have database owner permissions to create, remove, or modify Microsoft Search full-text catalogs.

注意：
The FullTextCatalog object is compatible with instances SQL Server version 7.0 and later. However, the FullTextCatalog2 object extends the functionality of the FullTextCatalog object for use with features that were introduced in SQL Server 2000.

请参阅

参考

FullTextCatalog2 Object

帮助和信息

获取 SQL Server 2005 帮助