MSG 15138 the Database Principal owns a schema in the database, and cannot be dropped.

Error When deleting a user:

 

MSG 15138, level16, state 1, line 1

The Database Principal owns a schemain the database, and cannot be dropped.

 

Solution (SSMs ):

 

1. Find the user's schema

 

 

2. Find the db_owner In the schema and change the schema owner from test6 to DBO or another user.

 

 

3. delete user test6

 

Or use the following statement to delete the file:

 

--- Query the schema owned by user test6 as db_owner

Use DBA;

Select S. Name

From SYS. schemas s

Where S. principal_id =
User_id ('test6 ');

 

-- Change the owner of db_owner schema to DBO.

Alter authorizationon
Schema: db_ownerto DBO;

 

--- Query the schema owned by user test6 again as null

Select S. Name

From SYS. schemas s

Where S. principal_id =
User_id ('test6 ');

 

-- Delete user test6

Drop user [test6]