sp_help_fulltext_columns (T-SQL)

Returns the columns that have been designated for full-text indexing.

Syntax

sp_help_fulltext_columns [[@table_name =] 'table_name'],
    [[@column_name =] 'column_name']

Arguments
[@table_name =] 'table_name'
Is the one- or two-part table name for which full-text index information is requested. table_name is nvarchar(517), with a default value of NULL. If table_name is omitted, full-text index column information is retrieved for every full-text indexed table.
[@column_name =] 'column_name'
Is the name of the column for which full-text index metadata is requested. column_name is sysname, with a default value of NULL. If column_name is omitted or is NULL, full-text column information is returned for every full-text indexed column for table_name. If table_name is also omitted or is NULL, full-text index column information is returned for every full-text indexed column for all tables in the database.
Return Code Values

0 (success) or (1) failure

Result Sets
Column name Data type Description
TABLE_OWNER sysname Table owner. This is the name of the database user that created the table.
TABLE_NAME sysname Name of the table.
FULLTEXT_COLID integer Column ID of the full-text indexed column.
FULLTEXT_COLUMN_NAME sysname Column in a full-text indexed table that is designated for indexing.

Permissions

Execute permissions default to members of the public role.

Examples

This example returns information about the columns that have been designated for full-text indexing in the Categories table.

USE Northwind

EXEC sp_help_fulltext_columns Categories

  

Here is the result set:

TABLE_OWNER     TABLE_NAME    FULLTEXT_COLID  FULLTEXT_COLUMN_NAME

-----------     -----------   --------------  --------------------

dbo             Categories    3               Description        

  

See Also
COLUMNPROPERTY sp_help_fulltext_columns_cursor
sp_fulltext_column System Stored Procedures

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.