BroadSQLOn this page
DEL CONNECTION
Core command
DEL CO
DELCO
DE CO
DECO
Deletes a database connection by making it inactive; it can be reactivated.
Syntax
DEL CONNECTION <id>Arguments
| Argument | Required | Values | Default |
|---|---|---|---|
<id> | Yes | The ID of an active connection | None |
Examples
DEL CONNECTION MYDB01;Details
A reversible deletion
The connection is marked inactive, not removed: its history is kept and it can be reactivated with REACTIVATE CONNECTION, or from the "Inactive connections" view of the CONFIG window, instead of being created again. HARDDEL removes an inactive connection permanently.
Confirmation
The command asks Delete connection '<id>' [y/n/c]?. Answer y to delete it, or n to keep it. Only n keeps the connection: no, c and cancel delete it too.
Errors
The connection must exist and be active. An inactive connection is reported as already inactive; an unknown ID gets the usual invalid ID error.
Related
Used in these how-tos
- How do I find the rows that differ between two databases?
- How do I export tables and query results with DUMP? A step-by-step tutorial
- How do I verify that a data fix changed only the intended rows?
Last modified in release 5.5.0.
Found something wrong or unclear on this page? Tell us, with the page address.