Fixed the error: 15138 The database principal owns a schema in the database, and cannot be dropped. - Drop the USER sql server 2008 r2

Error: 15138 The database principal owns a schema in the database, and cannot be dropped.

Cause: That means, you are trying to drop a user owning a schema. In order to drop the user, you have to find the schema that’s assigned and then transfer the ownership to another user/role or to drop it.

Resolution: You can fix the issue following two ways.

Step 1 :
By script: You can find out which schema is owned by this user with the query below:

SELECT name FROM sys.schemas WHERE principal_id = USER_ID('myUser')
Step 2 :
Then, use the names found from the above query below in place of the SchemaName below. And drop your user.

ALTER AUTHORIZATION ON SCHEMA::SchemaName TO dbo

GO
Step 3 :
DROP USER myUser