Class InformationSchema.ViewTableUsage

Namespace

LinqToDB.Tools.DataProvider.SqlServer.Schemas

Assembly

linq2db.Tools.dll

VIEW_TABLE_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 table in the current database that is used in a view. 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_TABLE_USAGE.

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

Inheritance

object

InformationSchema.ViewTableUsage

Extension Methods

Map.DeepCopy<T>(T)

Properties

TableCatalog

Table qualifier.

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

Property Value

string

TableName

Base table that the view is based on.

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

Property Value

string

TableSchema

Name of schema that contains the base 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