Home SQL Server Commands
 

DROP ROUTE

Delete a route from the current database, (delete from the routing table.)

Syntax
      DROP ROUTE route [;]
	  
Key
   route     The route to drop. 

If a route is dropped while in use by a conversation, then the conversation will remain in the transmission queue (often until it times out.)

Example

DROP ROUTE MyRoute ;

"Get your kicks on ROUTE 66" - Jack Kerouac

Related commands:

CREATE ROUTE
ALTER ROUTE
sys.routes - List routing table

Equivalent Oracle command:

DBMS_JOB



Back to the Top

Simon Sheppard
SS64.com