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

sorry but...bump

Keith Chisarik

Hi Keith,



I think it is a problem with MS-SQL. Using other tools to design the tables, I have noticed that in order to keep the columns in the same order as I design them, it will have to rename the table, create a new one with the current field order, then copy the data from the renamed table, and then delete the renamed table.



If you want I can send you a copy of the script that is being generated for this "Copy" functionality.

Edhy Rijo

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

I want the tool to do this for me, ideally. Ill try your idea if Trent doent come up with something. I think the DDT should do this, perhaps it does I just dont know of a secret setting or trick (I hope).

Keith Chisarik

Me too.

Edhy Rijo