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 ?
What do you mean with different companies? In 1 SQL database? What is column sequence? What is the difference? What version? OnPrem I assume?
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.
Strange problem ofcourse but is also causing issues?
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.