Order of fields in a table.

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. Received on Fri Jul 04 2003 - 07:02:02 CDT