Skip to main content
Skip table of contents

COMPACT

When a user executes the SQL command DELETE, data is logically deleted. The COMPACT command permanently removes deleted lines from Indexima structures.

Syntax

SQL
ALTER TABLE <table> COMPACT

<table>

The table you want to compact.

Output

This SQL command does not return anything.


This operation can trigger a COMMIT if required before.





JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.