Table of Contents

Class InformationSchema.ViewColumnUsage

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

VIEW_COLUMN_USAGE (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 each column in the current database that is used in a view definition. This information schema view returns information about the objects to which the current user has permissions.
To retrieve information from these views, specify the fully qualified name of INFORMATION_SCHEMA._view_name_.


See INFORMATION_SCHEMA.VIEW_COLUMN_USAGE.

[Table(Schema = "INFORMATION_SCHEMA", Name = "VIEW_COLUMN_USAGE", IsView = true)]
public class InformationSchema.ViewColumnUsage
Inheritance
InformationSchema.ViewColumnUsage
Extension Methods

Properties

ColumnName

Column name.

[Column("COLUMN_NAME")]
[Nullable]
public string? ColumnName { get; set; }

Property Value

string

TableCatalog

Table qualifier.

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

Property Value

string

TableName

Base table.

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

Property Value

string

TableSchema

Name of schema that contains the table.

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

ViewCatalog

View qualifier.

[Column("VIEW_CATALOG")]
[Nullable]
public string? ViewCatalog { get; set; }

Property Value

string

ViewName

View name.

[Column("VIEW_NAME")]
[NotNull]
public string ViewName { get; set; }

Property Value

string

ViewSchema

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("VIEW_SCHEMA")]
[Nullable]
public string? ViewSchema { get; set; }

Property Value

string