ASPNETDB Database

Table: aspnet_Applications

Description

Used by ASP.NET features to provide an application scope for data.

Columns

Name  Type  Required?  Defaults To  Description 
ApplicationName  nvarchar(256)  Yes    Application name
LoweredApplicationName  nvarchar(256)  Yes    Application name (lowercase)
ApplicationId  uniqueidentifier  Yes  (newid())  Application ID
Description  nvarchar(256)  No    Application description

Relationships

Primary Table  Primary Key  Foreign Table  Foreign Key 
aspnet_Applications  ApplicationId  aspnet_Users  ApplicationId 
aspnet_Applications  ApplicationId  aspnet_Membership  ApplicationId 
aspnet_Applications  ApplicationId  aspnet_Roles  ApplicationId 
aspnet_Applications  ApplicationId  aspnet_Paths  ApplicationId 

Indexes

Name  Type  Columns 
aspnet_Applications_Index  Non-unique, Clustered  LoweredApplicationName 
PK__aspnet_Applicati__7E6CC920  Unique  ApplicationId 
UQ__aspnet_Applicati__00551192  Unique  ApplicationName 
UQ__aspnet_Applicati__7F60ED59  Unique  LoweredApplicationName 

Referencing Views

Name 
vw_aspnet_Applications 

Definition

CREATE TABLE [aspnet_Applications]
(
    [ApplicationName] nvarchar(256) NOT NULL,
    [LoweredApplicationName] nvarchar(256) NOT NULL,
    [ApplicationId] uniqueidentifier NOT NULL DEFAULT ((newid())),
    [Description] nvarchar(256) NULL
    CONSTRAINT [PK_aspnet_Applications] PRIMARY KEY
    (
        [ApplicationId]
    )
)

ASP.NET 2.0 Provider Database