Skip to main content

CHECK EXISTS (bSQL) | Blockpoint Docs

Backs up the specified database or blockchain. For examples, see Examples.

bSQL Syntax Conventions

Syntax

CHECK EXISTS { database_name | database_name.blockchain_name }

Arguments

database_name
The name of the database to be looked up.

blockchain_name
The name of the blockchain to looked up.

Return Value

Returns TRUE if the database or blockchain exists in the system.

Permissions

READ permission required on the database.

READ permissions default to members of the admin fixed database role. Members of the admin role can transfer permissions to other users.

Examples

A. Checking the existence of a Database.

The following example checks the existence of the "main" database.

CHECK EXISTS main

B. Checking the existence of a Blockchain.

The following example checks the existence of users in the main database.

CHECK EXISTS main.users