sys.fulltext_document_types (Transact-SQL)
Returns a row for each document type that is available for full-text indexing operations. Each row represents the IFilter interface that is registered in the instance of SQL Server.
Column name |
Data type |
Description |
|---|---|---|
document_type |
sysname |
The file extension of the supported document type. This value can be used to identify the filter that will be used during full-text indexing of columns of type varbinary(max) or image. |
class_id |
uniqueidentifier |
GUID of the IFilter class that supports file extension. |
path |
nvarchar(260) |
The path to the IFilter DLL. The path is only visible to members of the serveradmin fixed server role. |
version |
sysname |
Version of the IFilter DLL. |
manufacturer |
sysname |
Name of the IFilter manufacturer. |
Permissions
In SQL Server 2005 and later versions, the visibility of the metadata in catalog views is limited to securables that a user either owns or on which the user has been granted some permission. For more information, see Metadata Visibility Configuration.