I am trying to delete a principal from the database but can't because it owns a schema. When I go to edit the user, however, the box to uncheck schemae is blue and unremovable. How can I remove the principal from these schemas?
Try the T-SQL to do this:
You can't drop a principal that is a schema owner, so the