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 ...
Get Microsoft® SQL Server 2012 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.