[SOLVED] New field - position in a table

[Keith Sayers]

I have an extant table to which I would like to add a new field - in the second position. First field is an ID which serves as the index and I would like the new field to come before all others. It appears that the only place I can add is at the end, below all others. I have tried various ways of moving it from there up the hierarchy but none has worked. I assume I am missing something - could anyone help, please? =
P.S. is there an emoticon for a bearded smiley? That is what the = should be.
_________________
Keith Sayers keiths@apex.net.au

[Sliderule]

1. [Solved] Changing field order in Table Design mode
   
   http://www.oooforum.org/forum/viewtopic.phtml?t=105278
   
   
2. [solved]How to Insert a new field in design view?
   
   http://www.oooforum.org/forum/viewtopic.phtml?t=70021

I hope this helps, please be sure to let me / us know.

Sliderule

Thanks to add [Solved] in your first post Title ( edit button ) if your issue has been fixed / resolved.

[Keith Sayers]

Well, well - ingenious! This worked :
ALTER TABLE "TableName"
ADD COLUMN "NewName" VARCHAR(40)
BEFORE "Extant Name"

Now that I know how to handle that SQL facility I may use it to solve other problems.

My thanks to everyone.
_________________
Keith Sayers keiths@apex.net.au