How can I change a table when full text search is enabled?
I have an address table where the city has an nvarchar datatype, but I want to change the nvarchar datatype to varchar. For this I write a script
ALTER TABLE Address ALTER COLUMN City varchar(50) null
but when i ran this i got an error message:
Msg 7614, Level 16, State 1, Line 1 Unable to edit or delete the City column because it is included for full text search.
So how can I resolve this error? I don't know anything about full text search.
+3
source to share
2 answers
You probably have a full text index on the table and that prevents you from changing the column with that.
So, you can try:
DROP FULLTEXT INDEX ON Address
And then try:
ALTER TABLE Address ALTER COLUMN City varchar(50) null
And then you should see what the index contains and recreate it
+2
source to share