This topic describes how to delete a database from an ApsaraDB RDS for SQL Server instance. You can delete a database by using the ApsaraDB for RDS console or an SQL statement.

Delete a database by using the ApsaraDB for RDS console

  1. Log on to the ApsaraDB for RDS console.
  2. In the left-side navigation pane, click Instances. In the top navigation bar, select the region where the target RDS instance resides.
    Select a region
  3. Find the target instance and click the instance ID.
  4. Find the database and in the Actions column click Delete.
  5. In the message that appears, click OK.

Delete a database by using an SQL statement

  1. Connect to the RDS instance to which the database belongs. For more information, see Connect to an ApsaraDB RDS for SQL Server instance.
  2. Run the following statement to delete the database:
    drop database <database name>;
    Note If the RDS instance runs SQL Server 2012 or later on RDS High-availability Edition, you can run the following stored procedure. This stored procedure deletes a specified database, removes the associated image, and closes the connection to the database.
    EXEC sp_rds_drop_database 'database name'

Related operations

Operation Description
DeleteDatabase Deletes a database from an ApsaraDB for RDS instance.