Returns the columns that have been designated for full-text indexing.
sp_help_fulltext_columns [[@table_name =] 'table_name'],
[[@column_name =] 'column_name']
0 (success) or (1) failure
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. |
Execute permissions default to members of the public role.
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
COLUMNPROPERTY | sp_help_fulltext_columns_cursor |
sp_fulltext_column | System Stored Procedures |