Sql Server

SQL | Full Text Index

SQL | Full Text Index

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

        WHEN 1 THEN 'Full-Text installed.'
        ELSE 'Full-Text is NOT installed.'

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()

Related Post

About Us

Community of IT Professionals

A Complete IT knowledgebase for any kind of Software Language, Development, Programming, Coding, Designing, Networking, Hardware and Digital Marketing.