sp_fulltext_column (T-SQL)

Specifies whether or not a particular column of a table participates in full-text indexing.

Syntax

sp_fulltext_column [@tabname =] 'qualified_table_name',
    [@colname =] 'column_name',
    [@action =] 'action'

Arguments

[@tabname =] 'qualified_table_name'

Is a one- or two-part table name. The table must exist in the current database. The table must have a full-text index, but the full-text index must be inactive. qualified_table_name is nvarchar(517), with no default value.

[@colname =] 'column_name'

Is the name of a column in qualified_table_name. The column must be a character column and cannot be a computed column. column_name is sysname, with no default.

[@action =] 'action'

Is the action to be performed. action is varchar(20), with no default value, and can be one of these values.

 

Value	Description
add	Adds column_name of qualified_table_name to the table’s inactive full-text index.
drop	Removes column_name of qualified_table_name from the table’s inactive full-text index.

Return Code Values

0 (success) or 1 (failure)

Result Sets

None

Permissions

Only qualified table owners or members of the db_ddladmin fixed database role can execute sp_fulltext_column.

Examples

This example adds the Description column from the Categories table to the table's full-text index.

USE Northwind

EXEC sp_fulltext_column Categories, Description, 'add'

See Also