Table: aspnet_Paths

Description

Used by the SQL Personalization Provider to store the path for which Web Parts personalization state has been saved.

Columns

Name	Type	Required?	Defaults To	Description
ApplicationId	uniqueidentifier	Yes		Application ID
PathId	uniqueidentifier	Yes	(newid())	Path ID
Path	nvarchar(256)	Yes		Path name
LoweredPath	nvarchar(256)	Yes		Path name (lowercase)

Relationships

Primary Table	Primary Key	Foreign Table	Foreign Key
aspnet_Applications	ApplicationId	aspnet_Paths	ApplicationId
aspnet_Paths	PathId	aspnet_PersonalizationAllUsers	PathId
aspnet_Paths	PathId	aspnet_PersonalizationPerUser	PathId

Indexes

Name	Type	Columns
aspnet_Paths_index	Unique, Clustered	ApplicationId, LoweredPath
PK__aspnet_Paths__44FF419A	Unique	PathId

Referencing Views

Name
vw_aspnet_WebPartState_Paths

Definition

CREATE TABLE [aspnet_Paths]
(
    [ApplicationId] uniqueidentifier NOT NULL,
    [PathId] uniqueidentifier NOT NULL DEFAULT ((newid())),
    [Path] nvarchar(256) NOT NULL,
    [LoweredPath] nvarchar(256) NOT NULL
    CONSTRAINT [PK_aspnet_Paths] PRIMARY KEY
    (
        [PathId]
    )
)

---

ASP.NET 2.0 Provider Database