O'Reilly logo

Microsoft® SQL Server 2012 Unleashed by Alex T. Silverstein, Chris Gallelli, Paul T. Bertucci, Ray Rankins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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:

Image Create FullText Index

Image 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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required