On this page
PURGE CONNECTION
Permanently deletes an inactive connection and its login script; DEL CONNECTION makes it inactive first.
Syntax
PURGE CONNECTION <id>
Arguments
| Argument | Required | Values | Default |
|---|---|---|---|
<id> | Yes | The ID of an inactive connection (case ignored) | None |
Examples
DEL CONNECTION OLDDB;
PURGE CONNECTION OLDDB;
Details
Permanently deletes an inactive connection from the CDF, with its login script lines. DEL CONNECTION makes a connection inactive (REACTIVATE CONNECTION brings it back); PURGE CONNECTION then removes it for good, as the Delete permanently action of the Connections tab of CONFIG does, with the same rules.
Refused for an active connection and for $CDF. Nothing else in the CDF names a connection except its login script, whose lines are deleted with it, in the same transaction. The ID is matched ignoring case. The command asks Permanently delete the connection '<id>'? This cannot be undone [y/n]?; only y or yes purges, and any other answer changes nothing. No connection is needed: the command works at BroadSQL>.
Related
- DEL CONNECTION, to make it inactive first
- SHOW INACTIVE CONNECTIONS
- REACTIVATE CONNECTION
Last modified in release 5.6.0.
Found something wrong or unclear on this page? Tell us, with the page address.