Ask Your Question

Can I modify table once it has been saved

asked 2018-01-17 23:23:09 +0200

JamesAB gravatar image

Hi, I have designed a table and saved it. Having done so I find I want to move a field to a new position and insert a new field. Can I do this, if so how?



edit retag flag offensive close merge delete


Which data base are you connecting to, e.g. HSQLDB, MySQL, ..? LO is fairly brain dead at doing this. But because I choose to normally connect to MariaDB (a MySQL clone) databases, I can use HeidiSQL to easily organize the order of my fields. While it's true that the computer doesn't care what order they are in, the human is often helped considerably by having them neat and tidy. For example I like to have ID first, Born date next, followed by other things, and often Notes at the end.

EasyTrieve gravatar imageEasyTrieve ( 2018-01-18 22:34:29 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2018-01-17 23:30:59 +0200

Ratslinger gravatar image


The position of fields within a table is unimportant. I have not actually done so, but I have seen where this can be done by getting into the depths of the database.

If you truly need to see positioning of the fields using the Base interface, you will have to delete the old & enter the new.

If this answers your question please tick the ✔ (upper left area of answer). It helps others to know there was an accepted answer.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-01-17 23:23:09 +0200

Seen: 137 times

Last updated: Jan 17 '18