full-text search

最新推荐文章于 2024-07-15 10:53:04 发布

最新推荐文章于 2024-07-15 10:53:04 发布 · 112 阅读

本文介绍如何在SQL Server中创建全文目录、唯一索引及全文索引，并详细解释了每个步骤的作用，包括设置文档ID的唯一索引、创建文档的全文索引等。

1,catalog

USE AdventureWorks;
GO
CREATE FULLTEXT CATALOG AdvWksDocFTCat;

2,unique, single-column, non-nullable index

CREATE UNIQUE INDEX ui_ukDoc ON Production.Document(DocumentID);

3,full-text index

CREATE FULLTEXT INDEX ON Production.Document
(
    Document                         --Full-text index column name 
        TYPE COLUMN FileExtension    --Name of column that contains file type information
        Language 2057                 --2057 is the LCID for British English
)
KEY INDEX ui_ukDoc ON AdvWksDocFTCat --Unique index
WITH CHANGE_TRACKING AUTO            --Population type;
GO