DeleteSitecore9Databases.sql

EXEC msdb.dbo.sp_delete_database_backuphistory @database_name = N'prefix_Core'
GO
USE [master]
GO
DROP DATABASE [prefix_Core]
GO

EXEC msdb.dbo.sp_delete_database_backuphistory @database_name = N'prefix_EXM.Master'
GO
USE [master]
GO
DROP DATABASE [prefix_EXM.Master]
GO

EXEC msdb.dbo.sp_delete_database_backuphistory @database_name = N'prefix_ExperienceForms'
GO
USE [master]
GO
DROP DATABASE [prefix_ExperienceForms]
GO

EXEC msdb.dbo.sp_delete_database_backuphistory @database_name = N'prefix_MarketingAutomation'
GO
USE [master]
GO
DROP DATABASE [prefix_MarketingAutomation]
GO

EXEC msdb.dbo.sp_delete_database_backuphistory @database_name = N'prefix_Master'
GO
USE [master]
GO
DROP DATABASE [prefix_Master]
GO

EXEC msdb.dbo.sp_delete_database_backuphistory @database_name = N'prefix_Messaging'
GO
USE [master]
GO
DROP DATABASE [prefix_Messaging]
GO

EXEC msdb.dbo.sp_delete_database_backuphistory @database_name = N'prefix_Processing.Pools'
GO
USE [master]
GO
DROP DATABASE [prefix_Processing.Pools]
GO

EXEC msdb.dbo.sp_delete_database_backuphistory @database_name = N'prefix_Processing.Tasks'
GO
USE [master]
GO
DROP DATABASE [prefix_Processing.Tasks]
GO

EXEC msdb.dbo.sp_delete_database_backuphistory @database_name = N'prefix_ReferenceData'
GO
USE [master]
GO
DROP DATABASE [prefix_ReferenceData]
GO

EXEC msdb.dbo.sp_delete_database_backuphistory @database_name = N'prefix_Reporting'
GO
USE [master]
GO
DROP DATABASE [prefix_Reporting]
GO

EXEC msdb.dbo.sp_delete_database_backuphistory @database_name = N'prefix_Web'
GO
USE [master]
GO
DROP DATABASE [prefix_Web]
GO

EXEC msdb.dbo.sp_delete_database_backuphistory @database_name = N'prefix_Xdb.Collection.Shard0'
GO
USE [master]
GO
DROP DATABASE [prefix_Xdb.Collection.Shard0]
GO

EXEC msdb.dbo.sp_delete_database_backuphistory @database_name = N'prefix_Xdb.Collection.Shard1'
GO
USE [master]
GO
DROP DATABASE [prefix_Xdb.Collection.Shard1]
GO

EXEC msdb.dbo.sp_delete_database_backuphistory @database_name = N'prefix_Xdb.Collection.ShardMapManager'
GO
USE [master]
GO
DROP DATABASE [prefix_Xdb.Collection.ShardMapManager]
GO