full-text search

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