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.
Note: Only documents with the manufacturer as Microsoft are supported on SQL Database.
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.
Send feedback about: