Please use the form below to provide your feedback. Because your feedback is valuable to us, the information you submit in this form is recorded in our issue tracking system (JIRA), which is publicly available. You can track the status of your feedback using the ticket number displayed in the dialog once you submit the form.

TRUNCATE Statements

  • reference
    +
    This topic describes how you use TRUNCATE statements to delete all the data in a collection in Enterprise Analytics.

    The TRUNCATE statement is used to immediately remove all data from a collection in Enterprise Analytics. Upon execution, all associated data files are deleted from storage, and the space is instantly reclaimed.

    This differs from the DELETE statement, which marks records for deletion and only reclaims space during a later compaction process.

    TRUNCATE is supported only for standalone and remote collections and is not available for external collections or views.

    When executed on a remote collection with a connected link, the link is temporarily disconnected, the TRUNCATE operation is performed, and the link is reconnected.

    Syntax

    Truncate EBNF 
    Truncate ::=  "TRUNCATE" "ANALYTICS"? "COLLECTION" QualifiedName ("IF" "EXISTS")?
    Truncate Diagram
    TRUNCATE

    The first QualifiedName resolves to a remote collection, a standalone collection or a synonym.

    Examples

    This example deletes all the data in a standalone collection named Orders:

      TRUNCATE COLLECTION database_name.scope_name.Orders;