Skip to main content

DROP BLOCKCHAIN (bbSQL) | Blockpoint Docs

Removes one or more blockchain definitions and all data, indexes, triggers, constraints, and permission specifications for those blockchains.

bSQL Syntax Conventions

Syntax

DROP { database_name.blockchain_name | blockchain_name }   

Arguments

database_name
Is the name of the database in which the blockchain was created.

blockchain_name
Is the name of the blockchain to be removed.

Remarks

  • DROP blockchain cannot be used to drop a blockchain that is referenced by a FOREIGN KEY constraint. The referencing FOREIGN KEY constraint or the referencing blockchain must first be dropped.
  • When a blockchain is dropped, rules or defaults on the blockchain lose their binding, and any constraints or triggers associated with the blockchain are automatically dropped. If you re-create a blockchain, you must rebind the appropriate rules and defaults, re-create any triggers, and add all required constraints.
  • If you delete all rows in a blockchain by using the ALTER statement the blockchain exists until it is dropped.

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

A. Dropping a blockchain in the current database

The following example removes the companies blockchain and its data, indexes, and permissions from the current database.

DROP financial.companies

See Also