Table of Contents

Class FullTextSearchSchema.IndexColumn

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

sys.fulltext_index_columns (Transact-SQL)

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

Contains a row for each column that is part of a full-text index.


See sys.fulltext_index_columns.

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

Properties

ColumnID

ID of the column that is part of the full-text index.

[Column("column_id")]
[NotNull]
public int ColumnID { get; set; }

Property Value

int

LanguageID

LCID of language whose word breaker is used to index this full-text column.

0 = Neutral.

For more information, see sys.fulltext_languages (Transact-SQL).

[Column("language_id")]
[NotNull]
public int LanguageID { get; set; }

Property Value

int

Object

objects (sys.objects)

[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = false)]
public ObjectSchema.Object Object { get; set; }

Property Value

ObjectSchema.Object

ObjectID

ID of the object of which this is part.

[Column("object_id")]
[NotNull]
public int ObjectID { get; set; }

Property Value

int

StatisticalSemantics

1 = This column has statistical semantics enabled in addition to full-text indexing.

[Column("statistical_semantics")]
[NotNull]
public int StatisticalSemantics { get; set; }

Property Value

int

TypeColumnID

ID of the type column that stores the user-supplied document file extension-'.doc', '.xls', and so forth-of the document in a given row. The type column is specified only for columns whose data requires filtering during full-text indexing. NULL if not applicable. For more information, see Configure and Manage Filters for Search.

[Column("type_column_id")]
[Nullable]
public int? TypeColumnID { get; set; }

Property Value

int?