O'Reilly logo

Microsoft® SQL Server 2008 R2 Unleashed by Alex T. Silverstein, Chris Gallelli, Paul 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 and Catalogs

In SQL 2008 full-text catalogs are “virtual.” They are just containers for full-text catalog properties like accent sensitivity or catalog rebuild or population statements. They live inside the database in SQL 2008, unlike SQL 2000 and 2005, where the catalogs and full-text indexes resided in the filesystem.

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 three commands for full-text index creation and maintenance:

CREATE FULLTEXT CATALOG

CREATE FULLTEXT INDEX

ALTER FULLTEXT INDEX

Let’s look at how they work.

CREATE FULLTEXT CATALOG

To create a full-text catalog in its simplest ...

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