Mike, If the order of the columns is important to you, the way to reorganize them is to create an empty table -- with the desired layout, and with a different table name.
Insert all the rows from the previous version of the table into the new table. Drop all indexes and constraints from the old table. Rename the old table to something else. Rename the new table to the old table name. Create all indexes and constraints on the new table. When you are content that you did it all correctly, drop the old version of the table. Bill On Mon, Apr 28, 2008 at 2:28 PM, Mike Casey <[EMAIL PROTECTED]> wrote: > Hey everyone, > > > > I am evaluating 8.0 for my current company. I added a few tables to a > database. I got the Primary Key stuck at the bottom of one of the tables > and I was trying to move it to the top for sanity sake and I just can't find > a way to do it. I try to follow a standard of the primary key at the top, > foreign keys at the bottom, and everything else in a somewhat logical > fashion. I am a little worried if I am not able to reorganize column names > as we add and remove features. > > > > Thanks for your input. > > > > *Michael Casey* > > *MIS Manager* > > QMI Security Solutions > > 1661 Glenlake Avenue > > Itasca, IL 60143 > > 800-446-2500 ext 1008 > > [EMAIL PROTECTED] <[EMAIL PROTECTED]> > > >
