TSQL: How to check if column is fulltext enabled?
full-text-search, sql-server, sql-server-2005, t-sql
Solution
You could try using the COLUMNPROPERTY() function.
DECLARE @value INT;
SELECT @value = COLUMNPROPERTY(OBJECT_ID('schema.table'), 'column_name', 'IsFulltextIndexed')
IF (@value = 1)
PRINT 'Fulltext column'
ELSE
PRINT 'No Fulltext column'
Problem
I need to modify a column definition, but I would like to check if the column is full text enabled first. Is there a way to do such a check in a TSQL script? I'm using SQL Server 2005.