Forum Discussion
Data Warehouse Randomising Order of Column Names
When quering a data warehouse table now, why are the names in some random order. Rather than how they were originally set?
When I do a select * they are in the correct order. But if you do New SQL Query > SELECT TOP 100 the columns are in a random order.
Very annoying
Hi adamlob,
This is expected behaviour right now. The UI builds an explicit column list using a metadata view that isn’t guaranteed to preserve creation order, so the column list can look “random.”
On Reddit a Microsoft employee stated that they will try to address this by the end of the year.
If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.
1 Reply
Hi adamlob,
This is expected behaviour right now. The UI builds an explicit column list using a metadata view that isn’t guaranteed to preserve creation order, so the column list can look “random.”
On Reddit a Microsoft employee stated that they will try to address this by the end of the year.
If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.