Interesting problem with my database
Currently I alter a table by adding three fields to it but now I need these three fields to be added as the first three columns instead of at the end.
How can I do this dynamically? Is there a field property in Alter that allows me to change the order?
I have seen a lot of people who need to change the order of columns create a new table and copy over information. That wouldn't be a big deal but the # of columns and names of columns is never fixed, so I don't know how I would dynamically capture these names and the number of fields.
Thanks for any ideas. I am really stuck!
Currently I alter a table by adding three fields to it but now I need these three fields to be added as the first three columns instead of at the end.
How can I do this dynamically? Is there a field property in Alter that allows me to change the order?
I have seen a lot of people who need to change the order of columns create a new table and copy over information. That wouldn't be a big deal but the # of columns and names of columns is never fixed, so I don't know how I would dynamically capture these names and the number of fields.
Thanks for any ideas. I am really stuck!
