Apache OpenOffice Community Forum

Posted: **Wed Dec 22, 2010 4:08 am**

The following method utilizes the Base GUI to reorder Table columns/fields. These steps apply to the default "Embedded database" utilizing the "HSQL database engine" as reflected in the Base status bar. Additional steps or workarounds may be necessary with non-embedded (external/existing/split) databases. Either way, this is not the expert approved method so backup your .odb file before proceeding.

: Right-click on the Table and select 'Copy'

: Right-click 'Paste' a new Table

: In the Copy table dialog, rename the Table and ensure 'Definition and data' is selected, then click 'Next'

Posted: **Wed Dec 22, 2010 4:14 am**

: Reorder columns by individual selection, leaving the left panel blank, and click 'Create'

: Verify the new Table and data!!! Then re-work any global relationships before deleting the original table...

: Click the 'Add Table' icon

Posted: **Wed Dec 22, 2010 4:25 am**

: Add the new Table to the Relationships window

: Create the same relationships in the new Table, mirroring those of the original Table

: Right-click each relationship in the original Table and 'Delete'

Posted: **Wed Dec 22, 2010 5:18 am**

: Again, after verifying the new Table and data, right-click 'Delete' the original

: Right-click 'Rename' the new Table (or re-accomplish the Table copy process above to rename non-embedded database Tables; or perhaps use Tools > SQL... to Execute: ALTER TABLE "OldName" RENAME TO "NewName")

: Use the original Table name for compatibility with existing work (Queries, etc.)

Posted: **Wed Dec 22, 2010 5:26 am**

: Reclaim the original database file size using SQL, click Tools > SQL...

: Type CHECKPOINT DEFRAG, then click 'Execute' ...and you're done!!!

Apache OpenOffice Community Forum

[Tutorial] Reorder Table Columns using the Base GUI

[Tutorial] Reorder Table Columns using the Base GUI

Continued...

Continued...

Continued...

And finally...