Have Geek Brain

How can I disable full text search on a column in sql server?

I'm trying to convert a column from ntext to nvarchar (MAX), but it seems like it has full text search on it.

Alter table <table> alter column <column> nvarchar

Then I'm going to force the text into lines

update <table> set <column> = <column> +'' where <column> is not null

Finally, I need to turn full text search back on.

How do I do this in SQL?

0


a source to share


2 answers 


DROP FULLTEXT INDEX ON mytable.mycolumn;
go
Alter table ... nvarchar(value);
go
ADD FULLTEXT INDEX ON mytable add (mycolumn)


( http://msdn.microsoft.com/en-us/library/ms188359.aspx )

+4


a source


This applies to SQL Server 2005.

The syntax for dropping a full-text index is:

ALTER FULLTEXT INDEX ON [TABLENAME] DROP (COLUMNNAME)



- ALTER COLUMN OR MORE STATEMENT -

The syntax for reading the FullText Index is:

ALTER FULLTEXT INDEX ON [TABLENAME] add (COLUMNNAME)

+3


a source






More articles:


All Articles