Skip to main content

DISCONNECT BLOCKCHAIN (bSQL) | Blockpoint Docs

Disconnects a blockchain from the database. For examples, see Examples.

bSQL Syntax Conventions

Syntax

DISCONNECT BLOCKCHAIN { database_name.blockchain_name | blockchain_name }

Arguments

database_name
Specifies the database in which the blockchain to be disconnected resides.

blockchain_name
Specifies the blockchain to be disconnected.

Permissions

  • Disconnected blockchains are inaccessible until they are re-connected using a CONNECT BLOCKCHAIN command.
  • Disconnecting a blockchain doesn't free the blockchains memory.

Permissions

MANAGEMENT permission required on the target blockchain.

MANAGEMENT permissions default to members of the admin and developer fixed database roles. Members of the admin role can transfer permissions to other users.

Examples

Disconnecting a Blockchain.

The following statement removes the blockchain pricing from the financial database.

DISCONNECT BLOCKCHAIN financial.pricing

See Also