The REORDER command allows you physically reorder a table by a different sort order. This can be useful it you want to go through a table record by record.
Syntax:
REORDER TABLE [TABLE NAME] BY column1 (optional desc),…, columnN (option desc)
Example: REORDER TABLE orders by ORDERID Desc
Overview
Content Tools