Table of Contents

Class FullTextSearchSchema.Index

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

sys.fulltext_indexes (Transact-SQL)

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

Contains a row per full-text index of a tabular object.


See sys.fulltext_indexes.

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

Properties

ChangeTrackingState

State of change-tracking.

M = Manual

A = Auto

O = Off

[Column("change_tracking_state")]
[Nullable]
public string? ChangeTrackingState { get; set; }

Property Value

string

ChangeTrackingStateDesc

Description of the state of change-tracking.

MANUAL

AUTO

OFF

[Column("change_tracking_state_desc")]
[Nullable]
public string? ChangeTrackingStateDesc { get; set; }

Property Value

string

CrawlEndDate

End of the current or last crawl.

NULL = None.

[Column("crawl_end_date")]
[Nullable]
public DateTime? CrawlEndDate { get; set; }

Property Value

DateTime?

CrawlStartDate

Start of the current or last crawl.

NULL = None.

[Column("crawl_start_date")]
[Nullable]
public DateTime? CrawlStartDate { get; set; }

Property Value

DateTime?

CrawlType

Type of the current or last crawl.

F = Full crawl

I = Incremental, timestamp-based crawl

U = Update crawl, based on notifications

P = Full crawl is paused.

[Column("crawl_type")]
[NotNull]
public string CrawlType { get; set; }

Property Value

string

CrawlTypeDesc

Description of the current or last crawl type.

FULL_CRAWL

INCREMENTAL_CRAWL

UPDATE_CRAWL

PAUSED_FULL_CRAWL

[Column("crawl_type_desc")]
[Nullable]
public string? CrawlTypeDesc { get; set; }

Property Value

string

DataSpaceID

Filegroup where this full-text index resides.

[Column("data_space_id")]
[NotNull]
public int DataSpaceID { get; set; }

Property Value

int

FulltextCatalogID

ID of the full-text catalog in which the full-text index resides.

[Column("fulltext_catalog_id")]
[Nullable]
public int? FulltextCatalogID { get; set; }

Property Value

int?

HasCrawlCompleted

Last crawl (population) that the full-text index has completed.

[Column("has_crawl_completed")]
[NotNull]
public bool HasCrawlCompleted { get; set; }

Property Value

bool

IncrementalTimestamp

Timestamp value to use for the next incremental crawl.

NULL = None.

[Column("incremental_timestamp")]
[Nullable]
public byte[]? IncrementalTimestamp { get; set; }

Property Value

byte[]

IsEnabled

1 = Full-text index is currently enabled.

[Column("is_enabled")]
[NotNull]
public bool IsEnabled { get; set; }

Property Value

bool

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 to which this full-text index belongs.

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

Property Value

int

PropertyListID

ID of the search property list that is associated with this full-text index. NULL indicates that no search property list is associated with the full-text index. To obtain more information about this search property list, use the sys.registered_search_property_lists (Transact-SQL) catalog view.

[Column("property_list_id")]
[Nullable]
public int? PropertyListID { get; set; }

Property Value

int?

StoplistID

ID of the stoplist that is associated with this full-text index.

[Column("stoplist_id")]
[Nullable]
public int? StoplistID { get; set; }

Property Value

int?

UniqueIndexID

ID of the corresponding unique, non-full-text index that is used to relate the full-text index to the rows.

[Column("unique_index_id")]
[NotNull]
public int UniqueIndexID { get; set; }

Property Value

int