Skip to content

Instantly share code, notes, and snippets.

@MahdiKarimipour

MahdiKarimipour/pellerex-create-sql-sever-full-text-index.sql

Created July 3, 2022 11:18
Show Gist options
  • Save MahdiKarimipour/ff6e445ef557adfba6bb39febff545e2 to your computer and use it in GitHub Desktop.
Save MahdiKarimipour/ff6e445ef557adfba6bb39febff545e2 to your computer and use it in GitHub Desktop.
Download ZIP
How to create Full-Text Index using SQL Server
Raw
pellerex-create-sql-sever-full-text-index.sql
CREATE FULLTEXT INDEX ON dbo.Addresses(FullAddress)
KEY INDEX PK_Addresses ON FTCAddress
WITH STOPLIST = OFF, CHANGE_TRACKING AUTO;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment