次の方法で共有


FullTextCatalog Object

この機能は、将来のバージョンの Microsoft SQL Server では削除される予定です。新規の開発作業ではこの機能を使用しないようにし、現在この機能を使用しているアプリケーションは修正することを検討してください。

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

現在のオブジェクトを表す SQL-DMO オブジェクト モデル

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.

ms141215.note(ja-jp,SQL.90).gifメモ :
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 の参考資料の入手