sys.fulltext_document_types

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 Microsoft SQL Server 2005.

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.

See Also

Reference

Catalog Views (Transact-SQL)

Help and Information

Getting SQL Server 2005 Assistance