On 10 Mar 2014 02:20:21 -0700, <thp_pkmi@...> wrote:

> Hi everybody, I'm not sure this is a right site to ask for request for

DML

> SQL, but I can stand any critics for this possible wrong post.
>
> I want to request a feature for firebird DML ie:
> ALTER TABLE <table> .. ALTER FIELD POSITION [BEFORE|AFTER] <field>..
> I'm sure this would be a big help in adding new fields to table w/ many
> many fields coz need not to count the sequence of new field position.

Feature requests should be reported in the tracker:
http://tracker.firebirdsql.org/browse/CORE

Note that given the current syntax to alter the position (see
http://www.firebirdsql.org/refdocs/langrefupd25-ddl-table.html#langrefupd25-at-position
), the following syntax will probably be better:

ALTER TABLE <table> .. ALTER [COLUMN] <columnname> POSITION {
<newposition> | {BEFORE|AFTER} <othercolumnname>}