Marc, The answer is almost never No, but sometimes Yes gets really complicated.
1) Backup your database. 2) SET MULTI OFF 3) CONNECT database 4) ALTER TABLE tablename ADD COLA datatype etc ALTER TABLE tablename ADD COLB datatype etc ALTER TABLE tablename ADD COLC datatype etc PROJECT tableX FROM tablename USING Co1, Col2, ColA, ColB, ColC, Col3, Col4, Col5 -- drop any constraints from tablename here DROP TABLE tablename RENAME TABLE tablex TO tablename -- use ALTER, CREATE, and RULES commands to create constraints, -- rules, and indexes on tablename Bill On Tue, Apr 6, 2010 at 12:12 PM, MDRD <[email protected]> wrote: > Hi > > I think the answer is No but I will ask anyway. > I want to insert 3 columns to the middle of a Table using a command file. > I have Col1, Col2, Col3, Col4, Col5 and I want to insert ColA, ColB, ColC > like this. > Col1, Col2 ,ColA, ColB, ColC , Col3, Col4, Col5 > > Is that possible? > > Thanks > Marc > >
