DROP UNDO — remove an undo segment
DROP UNDO [ IF EXISTS ] name [, ...]
DROP UNDO drops an existing undo segment from the database system. To execute this command you must be the owner of the undo segment.
Do not throw an error if the undo segment does not exist. A notice is issued in this case.
The name (optionally schema-qualified) of an undo segment to remove.
This command will remove the undo segment
DROP UNDO undo_15;
DROP UNDO is a Redrock Postgres language extension. There are no provisions for undo segments in the SQL standard.