While deleting MSSQL database from SQL management studio you may receive the below error:
The database principal owns a schema in the database, and cannot be dropped. (Microsoft SQL Server, Error: 1513
You can run the below script to get the schema details for the database.
USE Databasename; SELECT s.name FROM sys.schemas s WHERE s.principal_id = USER_ID('YourUserID');
Now use the below script to alter authorization on schema which you have received from the above script
ALTER AUTHORIZATION ON SCHEMA::YourSchemaName TO dbo;
You should now delete the database.