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 √ Azure SQL Database √ Azure SQL Managed Instance

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
Inherited Members
Extension Methods

Properties

ChangeTrackingState

change_tracking_state NULL char(1)

State of change-tracking.

M = Manual

A = Auto

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

Property Value

string

ChangeTrackingStateDesc

change_tracking_state_desc NULL nvarchar(60)

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

crawl_end_date NULL datetime

End of the current or last crawl.

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

Property Value

DateTime?

CrawlStartDate

crawl_start_date NULL datetime

Start of the current or last crawl.

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

Property Value

DateTime?

CrawlType

crawl_type NOT NULL char(1)

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

crawl_type_desc NULL nvarchar(60)

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

data_space_id NOT NULL int

Filegroup where this full-text index resides. 
[Column("data_space_id")]
[NotNull]
public int DataSpaceID { get; set; }

Property Value

int

FulltextCatalogID

fulltext_catalog_id NULL int

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

has_crawl_completed NOT NULL bit

Last crawl (population) that the full-text index has completed. 
[Column("has_crawl_completed")]
[NotNull]
public bool HasCrawlCompleted { get; set; }

Property Value

bool

IncrementalTimestamp

incremental_timestamp NULL binary(8)

Timestamp value to use for the next incremental crawl.

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

Property Value

byte[]

IsEnabled

is_enabled NOT NULL bit

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

object_id NOT NULL int

ID of the object to which this full-text index belongs. 
[Column("object_id")]
[NotNull]
public int ObjectID { get; set; }

Property Value

int

PropertyListID

property_list_id NULL int

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

stoplist_id NULL int

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

unique_index_id NOT NULL int

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