Delete BizTalk Application from BizTalk Mng DB

For delete an BizTalk Application directly from

BizTalk Mngmt DB you can use next query.

use BizTalkMgmtDb

SELECT * FROM [BizTalkMgmtDb].[dbo].[bts_application] where nvcName ='BizTalk Application Name'

SELECT * FROM [dbo].[bts_application_reference] where nApplicationID = <from above query>

SELECT * FROM dbo.bts_sendport where nApplicationID = <from first query>

--DELETE FROM [dbo].[bts_application_reference] where nApplicationID = <from first query>

--DELETE FROM [dbo].[bts_application] where nvcName ='Application Name'

--DELETE FROM dbo.bts_sendport where nApplicationID = <from first query>