Table of Contents

Class FullTextSearchSchema.Catalog

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

sys.fulltext_catalogs (Transact-SQL)

Applies to: √ SQL Server (all supported versions)

Contains a row for each full-text catalog.

note


The following columns will be removed in a future release of SQL Server: data_space_id, file_id, and path. Do not use these columns in new development work, and modify applications that currently use any of these columns as soon as possible.


See sys.fulltext_catalogs.

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

Properties

DataSpaceID

Filegroup where this catalog was created.

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

Property Value

int?

FileID

File ID of the full-text file associated with the catalog.

[Column("file_id")]
[Nullable]
public int? FileID { get; set; }

Property Value

int?

FulltextCatalogID

ID of the full-text catalog. Is unique across the full-text catalogs in the database.

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

Property Value

int

IsAccentSensitivityOn

Accent-sensitivity setting of the catalog.

True = Is accent-sensitive.

False = Is not accent-sensitive.

[Column("is_accent_sensitivity_on")]
[NotNull]
public bool IsAccentSensitivityOn { get; set; }

Property Value

bool

IsDefault

The default full-text catalog.

True = Is default.

False = Is not default.

[Column("is_default")]
[NotNull]
public bool IsDefault { get; set; }

Property Value

bool

IsImporting

Indicates whether the full-text catalog is being imported:

1 = The catalog is being imported.

2 = The catalog is not being imported.

[Column("is_importing")]
[NotNull]
public bool IsImporting { get; set; }

Property Value

bool

Name

Name of the catalog. Is unique within the database.

[Column("name")]
[NotNull]
public string Name { get; set; }

Property Value

string

Path

Name of the catalog directory in the file system.

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

Property Value

string

PrincipalID

ID of the database principal that owns the full-text catalog.

[Column("principal_id")]
[Nullable]
public int? PrincipalID { get; set; }

Property Value

int?