Skip to main content

DROP INDEX (bSQL) | Blockpoint Docs

Drops a user defined index on the specified blockchain. For examples, see Examples.

bSQL Syntax Conventions

Syntax​

DROP INDEX [IF EXISTS] "index_name"
 ON {
    <object>
    }

 <object> ::=  
 {   
    database_name . blockchain_name   
    | blockchain_name    

 }

Arguments​

index_name The name of the index to be dropped.

database_name
The name of the database.

blockchain_name
The name of the blockchain in which the index has been created on.

Remarks​

  • PRIMARY KEY indexes can't be dropped.
  • If the blockchain doesn't have an index named index_name the command will error unless IF EXISTS is specified.
  • UNIQUE constraints can only be dropped using the ALTER BLOCKCHAIN command.

Permissions​

ALTER permissions required on the target blockchain.

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

Dropping an index from a blockchain.​

The following example drops the "price tracker" ALT3 index from the financial.pricing blockchain in the Demo Database.

DROP INDEX "price tracker" ON financial.pricing

See Also​