Class InformationSchema.View

Namespace

LinqToDB.Tools.DataProvider.SqlServer.Schemas

Assembly

linq2db.Tools.dll

VIEWS (Transact-SQL)

Applies to: √ SQL Server (all supported versions) √ Azure SQL Database √ Azure SQL Managed Instance √ Azure Synapse Analytics √ Analytics Platform System (PDW)

Returns one row for views that can be accessed by the current user in the current database.
To retrieve information from these views, specify the fully qualified name of INFORMATION_SCHEMA._view_name_.

See INFORMATION_SCHEMA.VIEWS.

[Table(Schema = "INFORMATION_SCHEMA", Name = "VIEWS", IsView = true)]
public class InformationSchema.View

Inheritance

object

InformationSchema.View

Extension Methods

Map.DeepCopy<T>(T)

Properties

CheckOption

Type of WITH CHECK OPTION. Is CASCADE if the original view was created by using the WITH CHECK OPTION. Otherwise, NONE is returned.

[Column("CHECK_OPTION")]
[Nullable]
public string? CheckOption { get; set; }

Property Value

string

IsUpdatable

Specifies whether the view is updatable. Always returns NO.

[Column("IS_UPDATABLE")]
[NotNull]
public string IsUpdatable { get; set; }

Property Value

string

TableCatalog

View qualifier.

[Column("TABLE_CATALOG")]
[Nullable]
public string? TableCatalog { get; set; }

Property Value

string

TableName

View name.

[Column("TABLE_NAME")]
[NotNull]
public string TableName { get; set; }

Property Value

string

TableSchema

Name of schema that contains the view.

Important only reliable way to find the schema of a object is to query the sys.objects catalog view.

[Column("TABLE_SCHEMA")]
[Nullable]
public string? TableSchema { get; set; }

Property Value

string

ViewDefinition

If the length of definition is larger than nvarchar(4000), this column is NULL. Otherwise, this column is the view definition text.

[Column("VIEW_DEFINITION")]
[Nullable]
public string? ViewDefinition { get; set; }

Property Value

string