Had same issue but nothing above helped me, I tried to delete and checked Close all active connection but it didn't worked.

So this helped right click on database:

• Tasks -> Bring offline -> When popup window is shown -> Check "Drop close all active connections"

• Tasks -> Bring online

• Delete -> Check "Close all active connections"

• Database deleted