Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

SQL. I don't know of a way to do this within Base easily. I typically use SQL Workbench or MySQL Workbench depending on what database I'm using. If the DB is empty, it is fairly simple. Take the SQL source displayed, re-arrange (cut & paste) what you want, Drop the old & create the new. If, however, you have data in the DB, it can be tedious. Create a new table with what you want then with SQL, copy the data from one table to another field by field. As a side note, there is no logical reason that fields have any sequence within a database.