Default sorting of table

Is there a way to change the default sorting of a table?
I would guess it would be default based on the primary key, but seems like that’s not the case.

When i change a column in my table to a foreign key, suddenly the table get sorted in a different way.
Is there a way to change this not by the question view?

(Looking at the dataset => then selecting a table)

Hi @cobalt

Please post “Diagnostic Info” from Admin > Troubleshooting, and which database you’re querying.

There’s no “default sorting” of the results - Metabase requests data from your database, so the ordering should be the same as what your database returns.

I’m unsure why you’re seeing different behavior, when changing the Field Type, but perhaps you could enable debug logging on your database (or explain analyze of the query) to get a better understanding of what is happening.