sp_help_fulltext_columns
Returns the columns 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_ID | integer | ID of 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. |
| FULLTEXT_BLOBTP_COLNAME | sysname | Column in a full-text indexed table that specifies the document type of the full-text indexed column. This value is only applicable when the full-text indexed column is an image column. |
| FULLTEXT_BLOBTP_COLID | integer | Column ID of the document type column. This value is only applicable when the full-text indexed column is an image column. |
| FULLTEXT_LANGUAGE | sysname | Language used for the full-text search of the column. |
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