T-SQL: How to all Full Text Index to include new columns?

Asked May 03 '19 at 15:47

Active May 03 '19 at 16:29

Viewed 45 times

I am hoping this is not a repeat, but I created my index and need to include more columns from my table to the index. I have been searching around, however, the general response is to delete it and start over.

Is there any way to just alter the Full Text Index to include my new columns?

This is what I have been playing around with according to documentation:

USE [mydb]
GO
ALTER FULLTEXT INDEX ON [dbo].[output]  
{   
   ADD ('col1', 'col2',' col3', 'col4', 'col5', 'col6')  //Error is here

}  
;
GO

The error I receive is : Msg 102, Level 15, State 1, Line 4 Incorrect syntax near '{'.

edited May 03 '19 at 16:29

asked May 03 '19 at 15:47

Paradigm

Haven't used full text indexing before, but looking at command syntax, I think you dont need the single-quotes around your column names. – jamie May 03 '19 at 17:58
I was also trying to figure out how to do this using the GUI – Paradigm May 03 '19 at 18:07
2

Does it work without the single quotes? – jamie May 03 '19 at 18:09
2

Remove '{' and '}' from the query and then run. – CuriousKid May 03 '19 at 18:18
That fixed it. Thanks Jamie – Paradigm May 03 '19 at 18:25
@Paradigm, Which one worked removing Single quotes or removing { } or both? – CuriousKid May 03 '19 at 18:35

T-SQL: How to all Full Text Index to include new columns?

0 Answers0