Table: aspnet_SchemaVersions

Description

Used to track the versions of schemas required by ASP.NET features.

Columns

Name	Type	Required?	Defaults To	Description
Feature	nvarchar(128)	Yes		Name of the application feature
CompatibleSchemaVersion	nvarchar(128)	Yes		Schema version required for compatibility
IsCurrentVersion	bit	Yes		1=Current version, 0=Not current version

Indexes

Name	Type	Columns
PK__aspnet_SchemaVer__08EA5793	Unique, Clustered	Feature, CompatibleSchemaVersion

Definition

CREATE TABLE [aspnet_SchemaVersions]
(
    [Feature] nvarchar(128) NOT NULL,
    [CompatibleSchemaVersion] nvarchar(128) NOT NULL,
    [IsCurrentVersion] bit NOT NULL
    CONSTRAINT [PK_aspnet_SchemaVersions] PRIMARY KEY
    (
        [Feature],
        [CompatibleSchemaVersion]
    )
)

---

ASP.NET 2.0 Provider Database