RE: move column position

2004-12-30 Thread Gaspar Bakos
Hi, RE: I believe this is what you are looking for: ALTER TABLE Images MODIFY Imcreatedat datetime NOT NULL default '-00-00 00:00:00' AFTER Imccdtemp; Thanks, Tom for the clue. Yes, this is what I tried, but it did not work. Seems like modify does not accept the AFTER part. I tried it

RE: move column position

2004-12-30 Thread Tom Crimmins
Sorry about that. You are correct using AFTER or FIRST with ALTER TABLE ... MODIFY is not supported until version 4. --- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -Original Message- Hi, RE: I believe this is what you are looking for: ALTER TABLE Images MODIFY

RE: move column position

2004-12-29 Thread Tom Crimmins
I believe this is what you are looking for: ALTER TABLE Images MODIFY Imcreatedat datetime NOT NULL default '-00-00 00:00:00' AFTER Imccdtemp; --- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -Original Message- From: Gaspar Bakos [mailto:[EMAIL PROTECTED] Sent: