Returns the columns designated for full-text indexing.
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 sys.fulltext_index_columns catalog view instead.
|Applies to: SQL Server ( SQL Server 2008 through current version), SQL Database.|
sp_help_fulltext_columns [ [ @table_name = ] 'table_name' ] ] [ , [ @column_name = ] 'column_name' ]
[ @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
|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.|
Execute permissions default to members of the public role.
The following example returns information about the columns that have been designated for full-text indexing in the
USE AdventureWorks2012; GO EXEC sp_help_fulltext_columns 'Production.Document'; GO