Class InformationSchema.Schema
- Namespace
- LinqToDB.Tools.DataProvider.SqlServer.Schemas
- Assembly
- linq2db.Tools.dll
SCHEMATA (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 schema in the current database. To retrieve information from these views, specify the fully qualified name of INFORMATION_SCHEMA._view_name_. To retrieve information about all databases in an instance of SQL Server, query the sys.databases (Transact-SQL) catalog view.
[Table(Schema = "INFORMATION_SCHEMA", Name = "SCHEMATA", IsView = true)]
public class InformationSchema.Schema- Inheritance
-
InformationSchema.Schema
- Extension Methods
Properties
CatalogName
Name of current database
[Column("CATALOG_NAME")]
[Nullable]
public string? CatalogName { get; set; }Property Value
DefaultCharacterSetCatalog
Always returns NULL.
[Column("DEFAULT_CHARACTER_SET_CATALOG")]
[Nullable]
public string? DefaultCharacterSetCatalog { get; set; }Property Value
DefaultCharacterSetName
Returns the name of the default character set.
[Column("DEFAULT_CHARACTER_SET_NAME")]
[Nullable]
public string? DefaultCharacterSetName { get; set; }Property Value
DefaultCharacterSetSchema
Always returns NULL.
[Column("DEFAULT_CHARACTER_SET_SCHEMA")]
[Nullable]
public string? DefaultCharacterSetSchema { get; set; }Property Value
SchemaName
Returns the name of the schema.
[Column("SCHEMA_NAME")]
[NotNull]
public string SchemaName { get; set; }Property Value
SchemaOwner
Schema owner name.
Important Do not use INFORMATION_SCHEMA views to determine the schema of an object. INFORMATION_SCHEMA views only represent a subset of the metadata of an object. The only reliable way to find the schema of an object is to query the sys.objects catalog view.
[Column("SCHEMA_OWNER")]
[Nullable]
public string? SchemaOwner { get; set; }