I tried to migrate a SQL Server database by Export Data-tier Application (.bacpac file) from an Amazon RDS instance to others, but import didn't succeed. So now I want to delete the database (which is empty) when I try to:
DROP DATABASE mydatabase;
I get the error:
Cannot drop the database 'mydatabase', because it does not exist or you do not have permission
We can use the RDSadmin rename function to change it to something else, this seems to fix the issue and allows you to drop it.
EXEC rdsadmin.dbo.rds_modify_db_name N'<OldName>', N'<NewName>'
Use this to just drop the DB.