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​