Azure SQL Data Warehouse - how to drop a database?

203 Views Asked by user8612046 At 15 September 2017 at 01:15

How to drop an Azure SQL Data Warehouse database? drop database T-SQL command does not apply to ASDW.

There are 2 best solutions below

wBob On 15 September 2017 at 09:17 BEST ANSWER

Azure SQL Data Warehouse does not support DROP DATABASE as per the current documentation:

Delete your database via the Azure portal.

Matt Usher On 15 September 2017 at 16:39

This is a doc bug. You can connect to the master database and run:

DROP DATABASE <database name>

I've already updated the docs to reflect this.