Thank you for your reference Michael.
I care about column order when I review the structure because I like related columns, such as first name and last name, to be close to each other. Also I like the primary key to be the first field.
I am now writing a program to migrate free tables to SQL Server and I would like to add primary keys in the first position after the migration is finished. Since this program is to be run many times at different customer sites I don't want to do it manually.
Alex
TIA,
Alex
>I know of nothing but check here:
>
>
http://www.swynk.com/>
>BTW, why does the column have to be in a specific position. Any SELECT query can put the columns in the order that you need.
>
>-Mike