| PK_Affiliates | Affiliates | 0 | clustered, unique, primary key located on PRIMARY |
| PK_AnonymousUsers | AnonymousUsers | 8 | clustered, unique, primary key located on PRIMARY |
| aspnet_Applications_Index | aspnet_Applications | 8 | clustered located on PRIMARY |
| PK__aspnet_A__C93A4C983B60C8C7 | aspnet_Applications | 16 | nonclustered, unique, primary key located on PRIMARY |
| UQ__aspnet_A__17477DE43E3D3572 | aspnet_Applications | 16 | nonclustered, unique, unique key located on PRIMARY |
| UQ__aspnet_A__309103314119A21D | aspnet_Applications | 16 | nonclustered, unique, unique key located on PRIMARY |
| aspnet_Membership_index | aspnet_Membership | 8 | clustered located on PRIMARY |
| PK__aspnet_M__1788CC4D59E54FE7 | aspnet_Membership | 16 | nonclustered, unique, primary key located on PRIMARY |
| PK__aspnet_P__1788CC4C70C8B53F | aspnet_Profile | 0 | clustered, unique, primary key located on PRIMARY |
| aspnet_Roles_index1 | aspnet_Roles | 0 | clustered, unique located on PRIMARY |
| PK__aspnet_R__8AFACE1B7C3A67EB | aspnet_Roles | 0 | nonclustered, unique, primary key located on PRIMARY |
| PK__aspnet_S__5A1E6BC14D7F7902 | aspnet_SchemaVersions | 8 | clustered, unique, primary key located on PRIMARY |
| aspnet_Users_Index | aspnet_Users | 8 | clustered, unique located on PRIMARY |
| aspnet_Users_Index2 | aspnet_Users | 16 | nonclustered located on PRIMARY |
| PK__aspnet_U__1788CC4D45DE573A | aspnet_Users | 16 | nonclustered, unique, primary key located on PRIMARY |
| aspnet_UsersInRoles_index | aspnet_UsersInRoles | 0 | nonclustered located on PRIMARY |
| PK__aspnet_U__AF2760AD01F34141 | aspnet_UsersInRoles | 0 | clustered, unique, primary key located on PRIMARY |
| PK_PackageAssemblies | Assemblies | 8 | clustered, unique, primary key located on PRIMARY |
| PK_Authentication | Authentication | 8 | clustered, unique, primary key located on PRIMARY |
| IX_Banners | Banners | 0 | nonclustered located on PRIMARY |
| IX_Banners_1 | Banners | 0 | nonclustered located on PRIMARY |
| PK_Banner | Banners | 0 | clustered, unique, primary key located on PRIMARY |
| IX_Classification | Classification | 0 | nonclustered located on PRIMARY |
| PK_VendorCategory | Classification | 0 | clustered, unique, primary key located on PRIMARY |
| PK_ContentItems | ContentItems | 8 | clustered, unique, primary key located on PRIMARY |
| PK_Content_MetaData | ContentItems_MetaData | 0 | clustered, unique, primary key located on PRIMARY |
| IX_ContentItems_Tags | ContentItems_Tags | 0 | nonclustered, unique located on PRIMARY |
| IX_ContentItems_Tags_TermID | ContentItems_Tags | 0 | nonclustered located on PRIMARY |
| PK_ContentItems_Tags | ContentItems_Tags | 0 | clustered, unique, primary key located on PRIMARY |
| PK_ContentTypes | ContentTypes | 8 | clustered, unique, primary key located on PRIMARY |
| PK_Dashboard | Dashboard_Controls | 8 | clustered, unique, primary key located on PRIMARY |
| IX_DesktopModulePermission | DesktopModulePermission | 16 | nonclustered, unique, unique key located on PRIMARY |
| PK_DesktopModulePermission | DesktopModulePermission | 8 | clustered, unique, primary key located on PRIMARY |
| IX_DesktopModules_FriendlyName | DesktopModules | 16 | nonclustered located on PRIMARY |
| IX_DesktopModules_ModuleName | DesktopModules | 16 | nonclustered, unique, unique key located on PRIMARY |
| PK_DesktopModules | DesktopModules | 16 | clustered, unique, primary key located on PRIMARY |
| IX_EventLog_LogGUID | EventLog | 16 | nonclustered located on PRIMARY |
| PK_EventLogMaster | EventLog | 16 | clustered, unique, primary key located on PRIMARY |
| IX_LogTypeKey_LogTypePortalID | EventLogConfig | 16 | nonclustered, unique located on PRIMARY |
| PK_EventLogConfig | EventLogConfig | 8 | clustered, unique, primary key located on PRIMARY |
| PK_EventLogTypes | EventLogTypes | 16 | clustered, unique, primary key located on PRIMARY |
| PK_EventQueue | EventQueue | 16 | clustered, unique, primary key located on PRIMARY |
| IX_FileName | Files | 16 | nonclustered, unique, unique key located on PRIMARY |
| IX_Files | Files | 16 | nonclustered located on PRIMARY |
| IX_Files_UniqueId | Files | 16 | nonclustered, unique, unique key located on PRIMARY |
| PK_File | Files | 8 | clustered, unique, primary key located on PRIMARY |
| IX_FolderPermission | FolderPermission | 16 | nonclustered, unique, unique key located on PRIMARY |
| IX_FolderPermission_Modules | FolderPermission | 16 | nonclustered located on PRIMARY |
| IX_FolderPermission_Permission | FolderPermission | 16 | nonclustered located on PRIMARY |
| IX_FolderPermission_Roles | FolderPermission | 16 | nonclustered located on PRIMARY |
| IX_FolderPermission_Users | FolderPermission | 16 | nonclustered located on PRIMARY |
| PK_FolderPermission | FolderPermission | 8 | clustered, unique, primary key located on PRIMARY |
| IX_FolderPath | Folders | 16 | nonclustered, unique, unique key located on PRIMARY |
| IX_Folders_UniqueId | Folders | 16 | nonclustered, unique, unique key located on PRIMARY |
| PK_Folders | Folders | 8 | clustered, unique, primary key located on PRIMARY |
| PK_HostSettings | HostSettings | 8 | clustered, unique, primary key located on PRIMARY |
| PK_HtmlText | HtmlText | 8 | clustered, unique, primary key located on PRIMARY |
| PK_HtmlTextLog | HtmlTextLog | 8 | clustered, unique, primary key located on PRIMARY |
| PK_HtmlTextUsers | HtmlTextUsers | 0 | clustered, unique, primary key located on PRIMARY |
| IX_LanguagePacks | LanguagePacks | 16 | nonclustered, unique located on PRIMARY |
| PK_LanguagePacks | LanguagePacks | 8 | clustered, unique, primary key located on PRIMARY |
| IX_Languages | Languages | 16 | nonclustered, unique located on PRIMARY |
| PK_Languages | Languages | 8 | clustered, unique, primary key located on PRIMARY |
| IX_Links | Links | 0 | nonclustered located on PRIMARY |
| PK__Links__67FE6514 | Links | 0 | nonclustered, unique, primary key located on PRIMARY |
| IX_Lists_ListName_ParentID | Lists | 32 | nonclustered located on PRIMARY |
| IX_Lists_ListName_Value_Text_ParentID | Lists | 40 | nonclustered, unique, unique key located on PRIMARY |
| IX_Lists_ParentID | Lists | 16 | nonclustered located on PRIMARY |
| PK_Lists | Lists | 16 | clustered, unique, primary key located on PRIMARY |
| PK_Messaging_Messages | Messaging_Messages | 8 | clustered, unique, primary key located on PRIMARY |
| PK_MetaData | MetaData | 8 | clustered, unique, primary key located on PRIMARY |
| IX_ModuleControls | ModuleControls | 40 | nonclustered, unique, unique key located on PRIMARY |
| IX_ModuleControls_ControlKey_ViewOrder | ModuleControls | 16 | nonclustered located on PRIMARY |
| PK_ModuleControls | ModuleControls | 16 | clustered, unique, primary key located on PRIMARY |
| IX_ModuleDefinitions | ModuleDefinitions | 16 | nonclustered, unique, unique key located on PRIMARY |
| IX_ModuleDefinitions_1 | ModuleDefinitions | 16 | nonclustered located on PRIMARY |
| PK_ModuleDefinitions | ModuleDefinitions | 8 | clustered, unique, primary key located on PRIMARY |
| IX_ModulePermission | ModulePermission | 16 | nonclustered, unique, unique key located on PRIMARY |
| IX_ModulePermission_Permission | ModulePermission | 16 | nonclustered located on PRIMARY |
| IX_ModulePermission_Roles | ModulePermission | 16 | nonclustered located on PRIMARY |
| IX_ModulePermission_Users | ModulePermission | 16 | nonclustered located on PRIMARY |
| PK_ModulePermission | ModulePermission | 8 | clustered, unique, primary key located on PRIMARY |
| IX_Modules | Modules | 16 | nonclustered located on PRIMARY |
| PK_Modules | Modules | 16 | nonclustered, unique, primary key located on PRIMARY |
| PK_ModuleSettings | ModuleSettings | 8 | clustered, unique, primary key located on PRIMARY |
| IX_Packages | Packages | 40 | nonclustered, unique located on PRIMARY |
| PK_Packages | Packages | 16 | clustered, unique, primary key located on PRIMARY |
| PK_PackageTypes_1 | PackageTypes | 8 | clustered, unique, primary key located on PRIMARY |
| IX_Permission | Permission | 16 | nonclustered, unique, unique key located on PRIMARY |
| PK_Permission | Permission | 8 | clustered, unique, primary key located on PRIMARY |
| IX_PortalAlias | PortalAlias | 16 | nonclustered, unique, unique key located on PRIMARY |
| PK_PortalAlias | PortalAlias | 8 | clustered, unique, primary key located on PRIMARY |
| IX_PortalDesktopModules | PortalDesktopModules | 16 | nonclustered, unique, unique key located on PRIMARY |
| PK_PortalDesktopModules | PortalDesktopModules | 8 | clustered, unique, primary key located on PRIMARY |
| IX_PortalLanguages | PortalLanguages | 16 | nonclustered, unique located on PRIMARY |
| PK_PortalLanguages | PortalLanguages | 8 | clustered, unique, primary key located on PRIMARY |
| IX_Portals_AdministratorId | Portals | 16 | nonclustered located on PRIMARY |
| IX_Portals_DefaultLanguage | Portals | 16 | nonclustered located on PRIMARY |
| PK_Portals | Portals | 16 | nonclustered, unique, primary key located on PRIMARY |
| PK_PortalSettings | PortalSettings | 8 | clustered, unique, primary key located on PRIMARY |
| IX_Profile | Profile | 16 | nonclustered, unique located on PRIMARY |
| PK_Profile | Profile | 8 | clustered, unique, primary key located on PRIMARY |
| IX_ProfilePropertyDefinition | ProfilePropertyDefinition | 16 | nonclustered, unique located on PRIMARY |
| IX_ProfilePropertyDefinition_PropertyName | ProfilePropertyDefinition | 16 | nonclustered located on PRIMARY |
| PK_ProfilePropertyDefinition | ProfilePropertyDefinition | 8 | clustered, unique, primary key located on PRIMARY |
| IX_RoleGroupName | RoleGroups | 0 | nonclustered, unique, unique key located on PRIMARY |
| PK_RoleGroups | RoleGroups | 0 | clustered, unique, primary key located on PRIMARY |
| IX_RoleName | Roles | 16 | nonclustered, unique, unique key located on PRIMARY |
| IX_Roles | Roles | 16 | nonclustered located on PRIMARY |
| PK_Roles | Roles | 16 | nonclustered, unique, primary key located on PRIMARY |
| PK_Schedule | Schedule | 8 | clustered, unique, primary key located on PRIMARY |
| IX_ScheduleHistory_NextStart | ScheduleHistory | 16 | nonclustered located on PRIMARY |
| IX_ScheduleHistory_StartDate | ScheduleHistory | 16 | nonclustered located on PRIMARY |
| PK_ScheduleHistory | ScheduleHistory | 16 | clustered, unique, primary key located on PRIMARY |
| PK_ScheduleItemSettings | ScheduleItemSettings | 0 | clustered, unique, primary key located on PRIMARY |
| PK_SearchCommonWords | SearchCommonWords | 16 | clustered, unique, primary key located on PRIMARY |
| PK_SearchIndexer | SearchIndexer | 0 | clustered, unique, primary key located on PRIMARY |
| IX_SearchItem | SearchItem | 16 | nonclustered, unique located on PRIMARY |
| PK_SearchItem | SearchItem | 8 | clustered, unique, primary key located on PRIMARY |
| IX_SearchItemWord | SearchItemWord | 72 | nonclustered, unique, unique key located on PRIMARY |
| PK_SearchItemWords | SearchItemWord | 16 | clustered, unique, primary key located on PRIMARY |
| PK_SearchItemWordPosition | SearchItemWordPosition | 16 | clustered, unique, primary key located on PRIMARY |
| IX_SearchWord | SearchWord | 16 | nonclustered, unique, unique key located on PRIMARY |
| PK_SearchWord | SearchWord | 16 | clustered, unique, primary key located on PRIMARY |
| IX_SiteLog | SiteLog | 0 | nonclustered located on PRIMARY |
| PK_SiteLog | SiteLog | 0 | clustered, unique, primary key located on PRIMARY |
| PK_SkinControls | SkinControls | 8 | clustered, unique, primary key located on PRIMARY |
| PK_SkinPackages | SkinPackages | 8 | clustered, unique, primary key located on PRIMARY |
| PK_Skins | Skins | 8 | clustered, unique, primary key located on PRIMARY |
| IX_SystemMessages | SystemMessages | 0 | nonclustered, unique, unique key located on PRIMARY |
| PK_SystemMessages | SystemMessages | 0 | clustered, unique, primary key located on PRIMARY |
| IX_TabModules | TabModules | 16 | nonclustered, unique, unique key located on PRIMARY |
| IX_TabModules_UniqueId | TabModules | 16 | nonclustered, unique, unique key located on PRIMARY |
| PK_TabModules | TabModules | 16 | clustered, unique, primary key located on PRIMARY |
| PK_TabModuleSettings | TabModuleSettings | 8 | clustered, unique, primary key located on PRIMARY |
| IX_TabPermission | TabPermission | 16 | nonclustered, unique, unique key located on PRIMARY |
| IX_TabPermission_Permission | TabPermission | 16 | nonclustered located on PRIMARY |
| IX_TabPermission_Roles | TabPermission | 16 | nonclustered located on PRIMARY |
| IX_TabPermission_Tabs | TabPermission | 16 | nonclustered located on PRIMARY |
| IX_TabPermission_Users | TabPermission | 16 | nonclustered located on PRIMARY |
| PK_TabPermission | TabPermission | 8 | clustered, unique, primary key located on PRIMARY |
| IX_Tabs_1 | Tabs | 16 | nonclustered located on PRIMARY |
| IX_Tabs_2 | Tabs | 16 | nonclustered located on PRIMARY |
| IX_Tabs_ContentID | Tabs | 16 | nonclustered located on PRIMARY |
| IX_Tabs_PortalID_ParentID | Tabs | 16 | nonclustered located on PRIMARY |
| IX_Tabs_UniqueId | Tabs | 16 | nonclustered, unique, unique key located on PRIMARY |
| PK_Tabs | Tabs | 16 | clustered, unique, primary key located on PRIMARY |
| IX_TabSettings_TabID_SettingName | TabSettings | 16 | clustered, unique located on PRIMARY |
| PK_ScopeTypes | Taxonomy_ScopeTypes | 8 | clustered, unique, primary key located on PRIMARY |
| PK_Taxonomy_Terms | Taxonomy_Terms | 0 | clustered, unique, primary key located on PRIMARY |
| PK_Taxonomy_Vocabulary | Taxonomy_Vocabularies | 8 | clustered, unique, primary key located on PRIMARY |
| PK_Taxonomy_VocabularyType | Taxonomy_VocabularyTypes | 8 | clustered, unique, primary key located on PRIMARY |
| PK_UrlLog | UrlLog | 0 | clustered, unique, primary key located on PRIMARY |
| IX_Urls | Urls | 0 | nonclustered, unique, unique key located on PRIMARY |
| PK_Urls | Urls | 0 | clustered, unique, primary key located on PRIMARY |
| IX_UrlTracking | UrlTracking | 0 | nonclustered, unique, unique key located on PRIMARY |
| PK_UrlTracking | UrlTracking | 0 | clustered, unique, primary key located on PRIMARY |
| IX_UserAuthentication | UserAuthentication | 0 | nonclustered, unique located on PRIMARY |
| PK_UserAuthentication | UserAuthentication | 0 | clustered, unique, primary key located on PRIMARY |
| IX_UserPortals | UserPortals | 16 | nonclustered located on PRIMARY |
| PK_UserPortals | UserPortals | 8 | clustered, unique, primary key located on PRIMARY |
| IX_UserProfile | UserProfile | 16 | nonclustered located on PRIMARY |
| IX_UserProfile_UserID_PropertyDefinitionID | UserProfile | 16 | nonclustered located on PRIMARY |
| PK_UserProfile | UserProfile | 8 | clustered, unique, primary key located on PRIMARY |
| IX_UserRoles | UserRoles | 16 | nonclustered located on PRIMARY |
| IX_UserRoles_1 | UserRoles | 16 | nonclustered located on PRIMARY |
| PK_UserRoles | UserRoles | 8 | clustered, unique, primary key located on PRIMARY |
| IX_Users | Users | 16 | nonclustered, unique, unique key located on PRIMARY |
| IX_Users_Email | Users | 16 | nonclustered located on PRIMARY |
| IX_Users_IsDeleted_DisplayName | Users | 16 | nonclustered located on PRIMARY |
| PK_Users | Users | 8 | clustered, unique, primary key located on PRIMARY |
| PK_UsersOnline | UsersOnline | 8 | clustered, unique, primary key located on PRIMARY |
| IX_VendorClassification | VendorClassification | 0 | nonclustered, unique, unique key located on PRIMARY |
| IX_VendorClassification_1 | VendorClassification | 0 | nonclustered located on PRIMARY |
| PK_VendorClassification | VendorClassification | 0 | clustered, unique, primary key located on PRIMARY |
| IX_Vendors | Vendors | 0 | nonclustered, unique, unique key located on PRIMARY |
| PK_Vendor | Vendors | 0 | clustered, unique, primary key located on PRIMARY |
| IX_Version | Version | 16 | nonclustered, unique, unique key located on PRIMARY |
| PK_Version | Version | 8 | clustered, unique, primary key located on PRIMARY |
| PK_WebServers | WebServers | 8 | clustered, unique, primary key located on PRIMARY |
| IX_Workflow | Workflow | 16 | nonclustered, unique located on PRIMARY |
| PK_Workflow | Workflow | 8 | clustered, unique, primary key located on PRIMARY |
| IX_WorkflowStates | WorkflowStates | 16 | nonclustered, unique located on PRIMARY |
| PK_WorkflowStates | WorkflowStates | 8 | clustered, unique, primary key located on PRIMARY |