How does one control the column order when maintaining fields in the DDT? Ideally the column order that ends up in SQL should match the order displayed in the DDT. It does not, additionally I have an occurrance where the column order is different when deployed to two different SQL servers even after the tables on both servers have been dropped. This is wreaking havoc with some import functions I have.

Keith Chisarik

Anyway, here is sample of the generated script in which it will rename, create new structure with fields in order then copy data back to new table, and delete renamed table.

Edhy Rijo