Page 1 of 1

Order of columns in Table definitions

Posted: Thu Sep 27, 2018 6:58 am
by skathaitrooney
Hello Experts,
I have a slight problem with the table definitions that i have imported from the database. When i view the columns in the table definition itself, the order is fine. But when i try to import it into a Netezza connector, the order of the columns completely randomizes.
Does anyone know about this? I tried to do the same with another table definition but this time the order was good after the import.

I have tried to re-import the table definition multiple time without any luck..

Anyone in a similar situation ?

Posted: Thu Sep 27, 2018 7:22 am
by chulett
Does it really matter, affect anything? Other than you, of course. :wink:

Posted: Fri Sep 28, 2018 4:01 am
by ray.wurlod
Do you notice any pattern, such as all the VarChar columns moved to the end?

Posted: Fri Sep 28, 2018 6:26 am
by skathaitrooney
There is no such pattern that i could recognize..