Skip to main content

CHECK VALIDITY (bSQL) | Blockpoint Docs

Checks for data corruption. For examples, see Examples.

bSQL Syntax Conventions

Syntax

CHECK VALIDITY;

Permissions

MANAGEMENT permissions required on the master database.

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

Remarks

  • An MDB validity checks scan for data corruption through the entire system.
  • It validates ALL blockchain hashes. If a hash fails, the command will error and return corruption information.

Examples

Checking the validity of the system.

The following example validates all blockchain hashes for the entire DBMS.

CHECK VALIDITY;

See Also