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
- Log on to the ApsaraDB for RDS console.
- In the left-side navigation pane, click Instances. In the top navigation bar, select the region where your RDS instance resides.
- Find your RDS instance and click its ID.
- In the left-side navigation pane, click Databases.
- Find the database that you want to delete and in the Actions column click Delete.
- In the message that appears, click OK.
Delete a database by using an SQL statement
- Connect to the RDS instance to which the database belongs. For more information, see Connect to an ApsaraDB RDS for SQL Server instance.
- Execute 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, run the following stored procedure. This stored procedure deletes the specified database, removes the associated image, and closes the connection to the database.
EXEC sp_rds_drop_database 'database name'
|DeleteDatabase||Deletes a database from an ApsaraDB RDS instance.|