To build your full-text catalogs and indexes, you need to use the
CREATE FULLTEXT commands.
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.
You use the
create fulltext index command to create full-text indexes. Your searches query full-text indexes to return results.
Create Fulltext Index command has several parameters:
Column Name ...