This is a simple but I hope helpful tip!
Recently, we had deployed an Azure SQL Database through Terraform.
Sadly an error occurred during the deployment, and the database was listed but inaccessible by the Azure portal or Azure CLI.
But, the database was accessible through SQL. Odd !
In order to delete the database, we just had to do it in SQL:
DROP DATABASE [your_database_name]
Hope this helps !