Error: "The Database Principal Owns A Schema In The Database, And Cannot Be Dropped"
This is very common error while we drop any sql user. This comes because particular user owns schema in database.
To fix same , Perform below steps:
1. Find schema owned by user
SELECT name FROM sys.schemas WHERE principal_id = USER_ID('myUser')
2. Then, use the names found from the above query below in place of the SchemaName below
ALTER AUTHORIZATION ON SCHEMA::SchemaName TO dbo
3. Drop your user.
DROP USER myUser