Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Returns the columns designated for full-text indexing.
Important
This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. Use the new sys.fulltext_index_columns catalog view instead. For more information, see sys.fulltext_index_columns (Transact-SQL).
.gif "Topic link icon")
Transact-SQL Syntax Conventions
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 |
int |
ID of the table. |
TABLE_NAME |
sysname |
Name of the table. |
FULLTEXT_COLUMN_NAME |
sysname |
Column in a full-text indexed table that is designated for indexing. |
FULLTEXT_COLID |
int |
Column ID of the full-text indexed column. |
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 a varbinary(max) or image column. |
FULLTEXT_BLOBTP_COLID |
int |
Column ID of the document type column. This value is only applicable when the full-text indexed column is a varbinary(max) or 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
The following example returns information about the columns that have been designated for full-text indexing in the Document table.
USE AdventureWorks;
GO
EXEC sp_help_fulltext_columns 'Production.Document';
GO
See Also
Reference
COLUMNPROPERTY (Transact-SQL)
sp_fulltext_column (Transact-SQL)
sp_help_fulltext_columns_cursor (Transact-SQL)
System Stored Procedures (Transact-SQL)