[EMAIL PROTECTED] wrote > > Hello ! > > I want to insert a new field into an existing table after/before an > existing field and i don't know how to code?! > > alter table xyz add column newcolumn position = after field > xxx ??? > position = 4 ??? > > Is there a way to do this ???? If not, what is the easiest workaround > ???? >
There is no chance to specify that the new column should be before/after one column in an existing table. You have to re-create your table. possible way: rename existing table to old_xyz create table xyz as select <use the wanted sequence of column> from old_xyz re-create indexes, synonyms, views, privileges on xyz. Or another workaround: rename existing table to old_xyz create view xyz as select <use the wanted sequence of column> from old_xyz re_create privileges on xyz. When doing DDL (creating indexes for example) you always have to use old_xyz. Elke SAP Labs Berlin > Any help welcomed > Albert > ''''' > ''''''''' > (0 0) > +---------oOO-------(_)-------------------+ > | Tel: 0541/5841-868 | > | Fax: 0541/5841-869 | > | Mail: mailto:[EMAIL PROTECTED] | > | Internet: http://www.piepenbrock.de | > +-------------------------------oOO-------+ > |__|__| > || || > ooO Ooo > > > -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
