Re: Order of fields in a table.

ben brugman wrote:

> Order of fields in a table.
>
> Do you insert fields in a table, or do you
> append all new fields to the end.
>
> I prefer to insert the fields, but inserting a field
> can be cumbersome and takes some time
> in a real live database. I am aware that applications
> should not use any order, but there are also humans
> seeing the order of the fields in the database.
> (Checking which fields exist and using general utilities
> etc.).
>
> What is common in your world, adding or inserting ?
>
> ben brugman.

Time spent worrying about the ordering of columns in a relational table are just wasted.

If you make more than one change a year there is something wrong with the design process.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)