sys.fulltext_document_types (Transact-SQL)
Applies to: 
SQL Server
Azure SQL Database
Azure SQL Managed Instance
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. |
Permissions
The visibility of the metadata in catalog views is limited to securables that a user either owns, or on which the user was granted some permission.