Removing/changing automatic query on the "data" tab

The query that is automatically run when you toggle "data" is causing my SQL to crash repeatedly. Is there anyway to change or remove this query from running when I open that tab?

what query is this (see sql log) ? please show it here.
does "causing my SQL to crash" really mean your server (mysqld) crashes ? or does the heidisql program crash ?
if server, what is the version of your server ? (SELECT @@version)

the query is along the lines of:

select * from table1
order by column1 desc
limit 1000

it doesn't crash sql per se, the query triggered just takes way too long to load (and I just don't need its results).

ok, that´s "too slow", quite different from crashing. you can select the number of records to load by this statement by selecting (menu) "Tools", "Preferences", tab "Data appearance", and then lowering the first number after "Number of rows displayed in data tab".

Is there anyway to change or remove this query from running when I open that tab?

When you don't need to see these rows, just don't activate the "Data" tab.

However, I assume the ORDER BY makes your query slow. So, once you have that data grid opened, you can reset sorting by pressing Alt+S, or by rightclick > "Reset sorting".

This worked. Thank you, much appreciated!