The DELETE statement conflicted with the REFERENCE constraint in membership table

To delete a user from the database i used ‘Membership.DeleteUser(user)‘ while doing smoke test it is working in development environment but not in testing environment.

The DELETE statement conflicted with the REFERENCE constraint “FK__aspnet_Us__UserI__47489C52”. The conflict occurred in database “TestDB”, table “dbo.aspnet_UsersInRoles”, column ‘UserId’.

After analysis the ‘aspnet_Users_DeleteUser‘ procedure i came to know all the views for aspnet membership are missing

using ‘SELECT * FROM sysobjects where type = ‘V’‘

Refrence: Roles and Views in the Application Services Database for SQL Server

Tagged: 'Membership.DeleteUser, conflicted with the REFERENCE constraint, Membership