SQL | Full Text Index
A special type of index that provides index access for full-text queries against character or binary column data.
A full-text index breaks the column into tokens and these tokens make up the index data.
This feature lets users and application run character-based lookups efficiently by creating a particular type of index referred to as a Full-Text Index.
This index can be built on the top of one or more columns for a particular table.
Check whether Full Text Feature is enabled or not
SELECT
CASE FULLTEXTSERVICEPROPERTY('IsFullTextInstalled')
WHEN 1 THEN 'Full-Text installed.'
ELSE 'Full-Text is NOT installed.'
END
;
If Not Installed, first install full text feature
after installation check for current DB
SELECT is_fulltext_enabled
FROM sys.databases
WHERE database_id = DB_ID()
