To add a route, use sp_cluster logical, "add". For example, to add a route for the logins “accounting” and “projects” to “SalesLC”, enter:
sp_cluster logical, "add", SalesLC, route, login, "accounting;projects"
To move a route from one logical cluster to another, use sp_cluster logical, “alter”. For example, to create a route to “My_LC” using the alias “SalesLC”, and then move the route from “My_LC” to “Your_LC”, enter:
sp_cluster logical, "add", My_LC, route, alias, SalesLC sp_cluster logical, "alter", Your_LC, route, alias, SalesLC
To drop a route, use sp_cluster logical, "drop". For example, to drop the login “projects” from “SalesLC”, enter:
sp_cluster logical, "drop", SalesLC, route, login, projects