SELECT * FROM

navuser1

Hi,

I have executed the following SQL query on a NAV Database for two different companies and I surprise to see the column sequence. It differs from one another.

SELECT * FROM CompanyName$TableName;

What is the reason behind it? How do I fix that ?

Thanks,
navuser1

irasoelbaks

Please post the query result and provide more info please. I don't know what the real problem is.
What do you mean with different companies? In 1 SQL database? What is column sequence? What is the difference? What version? OnPrem I assume?

navuser1

I ran the below queries for two different company in a single database (OnPrem)

• SELECT * FROM [CRONUS India Ltd_$Customer]
• SELECT * FROM [CRONUS Test Ltd_$Customer]

And I saw the below screenshot in the Result windows(for example).




Please give a look at Column No_, the column sequence should be the same.

irasoelbaks

Please check the table definition in SSMS, is the column sequence in both companies the same?


Strange problem ofcourse but is also causing issues?

navuser1

We never ever touched the table definition from the Navision end ( using developer environment) or from the SQL end.

irasoelbaks

Thanks, good to know.
If it's not causing any issues you can ignore this strange behaviour IMO
If you want to further investigate you can restore some default Cronus databases and compare the results.