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