Deleting Databases in AzureSQL
Simple and Easy-to-Understand Examples:
There are different ways to delete a database in Azure SQL. In this article, we will discuss two methods:
Method 1: Delete a Database using Azure Portal
Step 1: Log in to the Azure Portal using your credentials.
Step 2: Navigate to the Azure SQL instance that contains the database you want to delete.
Step 3: Click on the “Databases” option on the left-hand side of the page.
Step 4: Select the database you want to delete from the list of databases.
Step 5: Click on the “Delete” button located at the top of the page.
Step 6: Confirm the deletion by clicking on the “Yes” button.
Method 2: Delete a Database using Azure CLI
Step 1: Open Azure CLI on your computer.
Step 2: Login to your Azure account using the command
"az login".
Step 3: Select the subscription that contains the Azure SQL instance by using the command “az account set –subscription <subscription name>”.
az account set --subscription <subscription name>
Step 4: Delete the database using the command “az sql db delete –resource-group <resource group name> –server <server name> –name <database name>”.
az sql db delete --resource-group <resource group name> --server <server name> --name <database name>
Step 5: Confirm the deletion by typing “y” and pressing Enter.
Microsoft Azure SQL Database | Complete Tutorial
Azure SQL Database is a relational database (RDBMS) service provided by Microsoft Azure that is widely used by developers when creating new applications in the cloud. It is managed completely by Microsoft and is a highly scalable platform-as-a-service (PaaS) designed especially for cloud applications. Here, we create a managed database server in the cloud and use the server to deploy our database. The server is a logical construct that acts as the central administration point for pooled databases or multiple logins, auditing rules, threat detection policy, and failover groups.
Table of Content
- Microsoft Azure SQL Database
- What is Microsoft Azure SQL Database?
- Azure SQL vs. SQL Server
- Why Azure SQL Database?
- SQL Azure Architecture
- Azure SQL Database Features
- Azure SQL Database Tiers
- Azure SQL Database Services
- Microsoft Azure SQL Database Hands-on
- Querying using Azure SQL Database
- Pricing Of Azure SQL Database
- Deleting Databases in AzureSQL
- Conclusion
- Azure SQL Database – FAQs