Microsoft® SQL Server 2008 R2 Unleashed

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