Table of Contents

Class FullTextSearchSchema.DocumentType

Namespace
LinqToDB.Tools.DataProvider.SqlServer.Schemas
Assembly
linq2db.Tools.dll

sys.fulltext_document_types (Transact-SQL)

Applies to: √ SQL Server (all supported versions) √ Azure SQL Database

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.


See sys.fulltext_document_types.

[Table(Schema = "sys", Name = "fulltext_document_types", IsView = true)]
public class FullTextSearchSchema.DocumentType
Inheritance
FullTextSearchSchema.DocumentType
Extension Methods

Properties

ClassID

GUID of the IFilter class that supports file extension.

[Column("class_id")]
[NotNull]
public Guid ClassID { get; set; }

Property Value

Guid

DocumentTypeColumn

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.

[Column("document_type")]
[NotNull]
public string DocumentTypeColumn { get; set; }

Property Value

string

Manufacturer

Name of the IFilter manufacturer.

Note: Only documents with the manufacturer as Microsoft are supported on SQL Database.

[Column("manufacturer")]
[Nullable]
public string? Manufacturer { get; set; }

Property Value

string

Path

The path to the IFilter DLL. The path is only visible to members of the serveradmin fixed server role.

[Column("path")]
[Nullable]
public string? Path { get; set; }

Property Value

string

Version

Version of the IFilter DLL.

[Column("version")]
[NotNull]
public string Version { get; set; }

Property Value

string