DROP ROUTE (Transact-SQL)
Drops a route, deleting the information for the route from the routing table of the current database.
Applies to: SQL Server (SQL Server 2008 through current version).
The routing table that stores the routes is a metadata table that can be read through the catalog view sys.routes. The routing table can only be updated through the CREATE ROUTE, ALTER ROUTE, and DROP ROUTE statements.
You can drop a route regardless of whether any conversations use the route. However, if there is no other route to the remote service, messages for those conversations will remain in the transmission queue until a route to the remote service is created or the conversation times out.