.NET CORE This feature is not supported by the .NET Core implementation of the Data Provider.

The tables created for the Views and ViewColumns will have the following definitions. For information of the columns of the tables refer to Views and ViewColumns.

The table definitions for both the Views and ViewColumns contain a columns that has a name of databasename. The information contained in this column is not made available to an application. It is used internally by the Entity Provider.

Views Store Schema Table Definition

CREATE TABLE ViewsTable (
   Id VARCHAR(256) CHARACTER SET UNICODE NOT CASESPECIFIC NOT NULL,
   DatabaseName VARCHAR(128) CHARACTER SET UNICODE NOT CASESPECIFIC NOT NULL,
   Name VARCHAR(128) CHARACTER SET UNICODE NOT CASESPECIFIC NOT NULL,
   ViewDefinition varchar(12500) CHARACTER SET UNICODE NOT CASESPECIFIC,
   IsUpdatable byteint
)
PRIMARY INDEX (Id)

ViewsTable is the table that is to be mapped to the Views store schema.

The information contained DatabaseName column is returned as the SchemaName.

ViewColumns Store Schema Table Definition

CREATE TABLE ViewColumnsTable (
   Id VARCHAR(384) CHARACTER SET UNICODE NOT CASESPECIFIC NOT NULL,
   ParentId VARCHAR(256) CHARACTER SET UNICODE NOT CASESPECIFIC,
   Name VARCHAR(128) CHARACTER SET UNICODE NOT CASESPECIFIC,
   DatabaseName VARCHAR(128) CHARACTER SET UNICODE NOT CASESPECIFIC,
   Ordinal integer,
   IsNullable byteint,
   TypeName VARCHAR(128) CHARACTER SET UNICODE NOT CASESPECIFIC,
   MaxLength integer,
   "Precision" integer,
   DateTimePrecision integer,
   Scale integer,
   CharacterSetName VARCHAR(128) CHARACTER SET UNICODE NOT CASESPECIFIC ,
   IsIdentity byteint,
   "Default" varchar(1024) CHARACTER SET UNICODE NOT CASESPECIFIC
)
PRIMARY INDEX(Id)

ViewColumnsTable is the table that is to be mapped to the ViewColumns store schema.

The information contained in the DatabaseName column is not made available to an application. It is used internally by the Entity Provider.