Microsoft® SQL Server 2012 Unleashed

Using T-SQL Commands to Build Full-Text Indexes

To build your full-text catalogs and indexes, you need to use the CREATE FULLTEXT commands.

Note

T-SQL commands are not case sensitive.

There are two commands for full-text index creation and maintenance:

Create FullText Index

Alter FullText Index

Let’s look at how they work.

CREATE FULLTEXT INDEX

You use the create fulltext index command to create full-text indexes. Your searches query full-text indexes to return results.

The Create Fulltext Index command has several parameters:

Column Name ...