InstantForum 2017-1 FinalStrataFrame Forumhttp://forum.strataframe.net/StrataFrame ForumSun, 17 May 2026 10:03:34 GMT20http://forum.strataframe.net/FindPost32464.aspxHello,<br/><br/>After creating a new table with the DDT, I realized that the field order is not as expected, which is causing problems downstream in an application.<br/><br/>I went into the DDT&nbsp;and reordered the fields, but that doesn't seem to do anything when I deploy to the server. Also, if I create a new database (i.e. deploy to server), the field order is just as it was when the original table was added to the database.<br/><br/><br/>UPDATE: I must have been seeing things regarding creating a new database, the field order is correct. However, if I deploy the updated field order to an existing database, the field order does not change.<br/><br/>Can anyone confirm?<br/><br/>BillTue, 25 Feb 2014 12:00:08 GMTWilliam Fieldshttp://forum.strataframe.net/FindPost32465.aspxHi Bill,<br/><br/>[quote][b]William Fields (2/25/2014)[/b][hr]Hello,<br/>After creating a new table with the DDT, I realized that the field order is not as expected, which is causing problems downstream in an application.<br/>Can anyone confirm?[/quote]<br/><br/>Yes, that is the behavior of the current DDT version.&nbsp; I believe it is a limitation of MS-SQL because I also use <a href="http://www.xcase.com/">xCase</a> for data modeling in some projects and they have an option to update a table by using the "Copy" command which will basically do the following:<br/><ol><li>Create a new table with a temporary name</li><li>Copy data from original table</li><li>Delete original table</li><li>Rename temporary table with original table name</li></ol>If you need your field names in the order you are designing them, then you may have to manually do the above to get them updated.&nbsp; I know it is a huge inconvenience, but hopefully new version of DDT for SF2.0 would take care of this issue.<br/><br/><br/>Tue, 25 Feb 2014 12:00:08 GMTEdhy Rijo