Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

how to lock column head buttons

1 posts

KBfriend posted 6 months ago in General

I clicked a column head in the data tab by mistake, and it run a 'sort by' query.
The table had more than 80M rows, so it leaded to service degradation.
Is there a way to lock column head buttons?

9823 posts

ansgar posted 6 months ago

No, there is no way to block that. But it could make sense to make that configurable, as the sorting dialog still provides a way to do the same. Just without the risk of doing it accidentally:

Description

Code modification/commit 7bea342 from Ansgar Becker <anse@heidisql.com>, 6 months ago, revision 6586

Make clicks on grid column headers configurable, so the user may disable it, preventing him from accidental sortings on large tables. See https://www.heidisql.com/forum.php?t=40026

9823 posts

ansgar posted 6 months ago

Next build has such an option to disable header clicks:

Description

Please login to leave a reply, or register at first.