Received: from www.base2inc.com (IDENT:root@www.base2inc.com [204.117.190.140]) by hub.org (8.9.1/8.9.1) with ESMTP id AAA25147 for ; Sun, 29 Nov 1998 00:34:56 -0500 (EST) (envelope-from fmorton@base2inc.com) Received: from tesla (tesla.base2inc.com [206.229.85.131]) by www.base2inc.com (8.8.7/8.8.7) with SMTP id AAA04671 for ; Sun, 29 Nov 1998 00:32:18 -0500 Message-ID: <005f01be1b5b$3d5ecef0$8355e5ce@tesla.base2inc.com> Reply-To: "Frank Morton" From: "Frank Morton" To: Subject: alter help needed Date: Sun, 29 Nov 1998 00:43:49 -0500 X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 4.72.2106.4 X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4 As an example, given a table with 2 columns, if I want to add a new column "between" the already existing columns, is there any way to use "alter table" to do this? The only way I can figure out how to do this and preserve the data is to dump the database and write a script to modify the dump by modifying the table structure plus the insert statements reflecting the change. This seems more painful and I must be missing an easier way to do this. I am trying to come up with an automated way to deal with multiple revisions of a database structure. Any help? Thanks. _________________________________ Frank Morton (fmorton@mail.base2inc.com) Voice: (317) 876-3355 FAX: (317) 876-3398 Home: (317) 574-0815