full-text search

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

iteye_4537

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

阅读量320

点赞数

文章标签：数据库开发工具

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