Re: add a new column into the middle of an existing table

Steven,

While I certainly can see your idea, I still think that users/developers that base their reports/GUI's/etc upon the physical structure of a DB are in for a surprise in the long run: "Stuff moves around".

I always insist that the users/developers that work on my DB's NEVER EVER use anything positionally, even in inserts with all the columns.

JP

Steven Healey <sphealey_at_worldnet.att.net> wrote in message news:<3CD09721.3080301_at_worldnet.att.net>...
> >J.P. wrote:
>
> > You gott'a stop thinking in non Relational-DB style...
> >
> > The physical location of a column is totally irrelevant in a RDBMS.
> >
> > JP
> >
> > leiwang_q_at_hotmail.com (lei wang) wrote in message news:<af074b9c.0204301247.65da02f9_at_posting.google.com>...
> >
> >>Is there an easy way to add a new column into the middle of an
> >>existing table?
>
> It is not however irrelevant to users of GUI-based tools such as Crystal
> Reports - particularly novice or light users. Typically in such tools
> columns can be displayed in either the natural order as stored in the
> database or in alphabetical order. However, the majority of reports hit
> a few key columns, and when a packaged software vendor adds a column at
> the end of the table that is often used with the first few columns the
> result is a pain in the wrist for the tool user.
>
> Experienced users may know methods for twisting column ordering around
> in report writers (and similar tools) to meet our needs, but it is still
> a pain.
>
> sPh
Received on Thu May 02 2002 - 07:37:12 CDT