| Subject | Re: [ib-support] Add a column after a specific field on existing tables |
|---|---|
| Author | Paul Vinkenoog |
| Post date | 2002-11-06T01:21:56Z |
Hi Kevin,
(I wonder why), but this always works:
ALTER TABLE <table> ADD <column> <datatype>
followed by
ALTER TABLE <table> ALTER <column> POSITION <1-based no.>
Greetings,
Paul Vinkenoog
> Is there a way to specify the column position for a new columnAFAIK, there is no way to specify the position when you add the column
> added to an existing table.
(I wonder why), but this always works:
ALTER TABLE <table> ADD <column> <datatype>
followed by
ALTER TABLE <table> ALTER <column> POSITION <1-based no.>
Greetings,
Paul Vinkenoog