Data Types MSSQL Tutorial

  1. Home
  2. MSSQL Tutorial
  3. Data Types
  4. Creating a Full-Text Index
USE YourDatabase
GO
CREATE FULLTEXT CATALOG cat_YourName
CREATE FULLTEXT INDEX ON MyDocumentTable
(DocumentSummary, Document TYPE COLUMN FileExtension)
KEY INDEX PK_DocumentID
ON cat_Document
WITH CHANGE_TRACKING AUTO