The TRIM statement is used to truncate the most recent data in a table.

The general syntax is

TRIM table_name num_rows

Above statement means number of rows to be truncated.

On the other hand, the user can also specify certain number of record to be preserved with following general syntax:

TRIM table_name TO row_number
Data will be permanently removed with TRIM statement, users should use this command with caution.


TRIM sales 20 --> Remove the last 20 rows of data in the sales table

TRIM sales TO 20 --> Every record after row 20 will be removed