SQL - TRUNCATE RECORD

Deletes a record or records without loading them. Useful in cases where the record is corrupted in a way that prevents OrientDB from correctly loading it.

Syntax

TRUNCATE RECORD <record-id>*
  • <record-id> Defines the Record ID you want to truncate. You can also truncate multiple records using a comma-separated list within brackets.

This command returns the number of records it truncates.

Examples

  • Truncate a record:

    orientdb> TRUNCATE RECORD 20:3
    
  • Truncate three records together:

    orientdb> TRUNCATE RECORD [20:0, 20:1, 20:2]
    

For more information, see