SALES: 1-800-867-1380

DROP DATABASE (Azure SQL Database)

This topic is OBSOLETE. You can find the most current version in the SQL 14 Transact-SQL Reference.

ImportantImportant
This topic is not maintained. For the current version, see DROP DATABASE.

Removes a database. You must be connected to the master database to drop a database.

Syntax Conventions (Azure SQL Database)


DROP DATABASE database_name 
[;]

This syntax diagram demonstrates the supported arguments in Microsoft Microsoft Azure SQL Database.

Microsoft Azure SQL Database does not support the database_snapshot_name argument when using the DROP DATABASE statement.

For more information about the arguments and the DROP DATABASE statement, see DROP DATABASE in SQL Server Books Online.

The DROP DATABASE statement must be the only statement in a SQL batch and you can drop only one database at a time.

Only the server-level principal login (created by the provisioning process) or members of the dbmanager database role can drop a database.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

Show:
© 2014 Microsoft