# 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.

<figure><img src="https://4102771481-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Ftn9fmavAcyzaE7MAMP2U%2Fuploads%2FhPzMNEMlOls6Y0PGAsIO%2FCreate_SQL_DB.png?alt=media&#x26;token=ded72cc3-da87-42e3-a66a-c67a4d0b1dd9" alt=""><figcaption><p><strong>Create SQL Database</strong></p></figcaption></figure>

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

<figure><img src="https://4102771481-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Ftn9fmavAcyzaE7MAMP2U%2Fuploads%2FZR0b0b7KpU0pVynDVemg%2FReview_DB_creation.png?alt=media&#x26;token=8faf77df-195e-4979-b63c-a174a775e4e3" alt=""><figcaption><p><strong>Review and Create</strong></p></figcaption></figure>

### 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.

<figure><img src="https://4102771481-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Ftn9fmavAcyzaE7MAMP2U%2Fuploads%2FT9dSWP5Z0B7VBjyn4QSw%2FDelete_DB.png?alt=media&#x26;token=ff2e9c0b-6bcc-44ef-ae12-ff1c71346476" alt=""><figcaption><p><strong>Delete the Database</strong></p></figcaption></figure>

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

<figure><img src="https://4102771481-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Ftn9fmavAcyzaE7MAMP2U%2Fuploads%2FJebbOXtBKc2ob2xM5pvQ%2FConfirm_Delete_DB.png?alt=media&#x26;token=c8c68846-beb2-4c5f-8c6c-9dd0281124c9" alt=""><figcaption><p><strong>Confirm Deletion</strong></p></figcaption></figure>
