Creating a Full-Text Index : FULLTEXT « Data Types « SQL Server / T-SQL Tutorial






  1. SQL Server / T-SQL Tutorial
  2. Data Types
  3. FULLTEXT
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








5.12.FULLTEXT
5.12.1.Creating a Full-Text Catalog
5.12.2.Creating a Full-Text Catalog and specify the path
5.12.3.Retrieving Full-Text Catalog and Index Metadata
5.12.4.Using FREETEXT to Search Full-Text Indexed Columns
5.12.5.Creating a Full-Text Index
5.12.6.Modifying a Full-Text Index
5.12.7.Dropping a Full-Text Catalog
5.12.8.Dropping a Full-Text Index