You can also use the below : Here it lists all Orphaned users on existing DB and delete Ids and associated Schema .

DECLARE @UserName varchar(100),

...