Creation and Deletion of Database

Let us see the steps to create and delete a database.

Creating the Database

1. Go to https://portal.azure.com/#home.

2. From the menu, choose Create a resource.

3. Select SQL Database in Azure Marketplace. You can also search 'SQL Database' using the search box and select the service SQL Database by Microsoft from the results.

4. Click on Create to begin the database creation process.

5. In the Basics tab of the creation wizard, enter the following information:

Subscription: Choose the subscription type you want for the database.

Resource group: Select an existing resource group or create a new one to organize your resources.

Database name: Enter a unique name for your database.

Server: Choose an existing SQL server or create a new one.

Create SQL Database

Go to Review+create tab. Review the summary of the settings and click on Create to start the database creation process.

Review and Create

Deleting the Database

1. Select the SQL database that you want to delete.

2. From the menu, click Overview.

3. Choose Delete on the right side of the window.

Delete the Database

1. Confirm the deletion by following the prompts. Enter any necessary confirmation details if required and Click Delete.

Confirm Deletion