Table: aspnet_Roles

Description

Used by the SQL Role Provider to store role data.

Columns

Name	Type	Required?	Defaults To	Description
ApplicationId	uniqueidentifier	Yes		Application ID
RoleId	uniqueidentifier	Yes	(newid())	Role ID
RoleName	nvarchar(256)	Yes		Role name
LoweredRoleName	nvarchar(256)	Yes		Role name (lowercase)
Description	nvarchar(256)	No		Role description (currently unused)

Relationships

Primary Table	Primary Key	Foreign Table	Foreign Key
aspnet_Applications	ApplicationId	aspnet_Roles	ApplicationId
aspnet_Roles	RoleId	aspnet_UsersInRoles	RoleId

Indexes

Name	Type	Columns
aspnet_Roles_index1	Unique, Clustered	ApplicationId, LoweredRoleName
PK__aspnet_Roles__31EC6D26	Unique	RoleId

Referencing Views

Name
vw_aspnet_Roles

Definition

CREATE TABLE [aspnet_Roles]
(
    [ApplicationId] uniqueidentifier NOT NULL,
    [RoleId] uniqueidentifier NOT NULL DEFAULT ((newid())),
    [RoleName] nvarchar(256) NOT NULL,
    [LoweredRoleName] nvarchar(256) NOT NULL,
    [Description] nvarchar(256) NULL
    CONSTRAINT [PK_aspnet_Roles] PRIMARY KEY
    (
        [RoleId]
    )
)

---

ASP.NET 2.0 Provider Database