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

• DELETE
• SQL Commands
• Console Commands