Drop databases in SQLServer Flex Instances

Prerequisites

In order to follow the steps described on this page, the following conditions need to be met:

• Your organization has a customer account.
  (See: Create a customer account)

• You have a User Account with the necessary permissions.
  (See: Create a user account, Identity and Access Management)

• You have a Project in your customer account.
  (See: Create a Project)

• You have created a Service Account.
  (See: Create a Service account)

• You have assigned the required project permissions to this service account.
  (See: Assign permissions to a service account)

• You have created an Access Token for this service account.
  (See: Assign authentication token to a service account)

• You have created a SQLServer Flex Instance.
  (See: Create a SQLServer Flex Instance)

• You are connected to the SQLServer Flex Instance.
  (See: Connect to a SQLServer Flex Instances)

• You previously created a database.
  (See: Create Databases in SQLServer Flex Instances)

If you proceed with the action described here, your data will be lost irrevocably.

Please check carefully,

• which of your data are affected,
• if those data are still in use or otherwise required to be present in your organization,
• and if a backup on your side is necessary, if it exists and if it is up to date and in usable condition.

Do not proceed unless you have checked the above points thoroughly and are authorized within your organization to delete the data.

Drop a Database

Portal

1. Navigate to the list of databases.
2. Open the ⋮ menu and select Delete.
3. Confirm by entering the name of the database and click Delete.

API

1. Paste the endpoint URL into the address bar: https://mssql-flex-service.api.eu01.stackit.cloud/v2/projects/{PROJECT_ID}/regions/{REGION}instances/{INSTANCE_ID}/databases/{DB_NAME} and replace {PROJECT_ID}, {INSTANCE_ID}, {REGION} and {DB_NAME} with the project ID, the instance ID and the name of the database of your SQL Server instance, respectively.

   Where do I find the Project ID?
   The project ID is displayed in the projects list of the Resource manager:
   

   Where do I find the Instance ID?
   The instance ID has the form of a UUID. It is displayed in the Overview tab of your instance in the STACKIT portal, in the section General information.
   For some products, the display of the instance ID in the portal is not implemented yet. In these cases the instance ID is visible as part of the instance URL in the address field of your browser when you are on the instance page in the portal, and it can be copied from there:
   

2. Select DELETE in the dropdown in front of the address bar

3. Execute the command by clicking Send.

Tranact SQL (T-SQL)

Execute the command drop database [databaseName] where [databaseName] is the name of the database.

For more insights about DROP DATABASE command and options, please visit Microsoft official documentation for SQL Server.