Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

sys.fulltext_document_types (Transact-SQL)

Applies To: SQL Server 2014, SQL Server 2016 Preview

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

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.

Applies to: SQL Server (SQL Server 2008 through current version), SQL Database V12.

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 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.

Community Additions

ADD
Show:
© 2015 Microsoft