Line breaks in View Select Statement

[expired user #9020]'s profile image [expired user #9020] posted 8 years ago in General Permalink

Is there anyway we could get the View: Select Statement text box to retain line breaks for the SQL code? It's pretty annoying and hard to read when you edit a View and it gets put on one line.

Thanks

ansgar's profile image ansgar posted 7 years ago Permalink

The server recompiles the view code after creating or altering it. To retain the original code, HeidiSQL tries to read it from the server's .frm file, but that fails in many cases, so the recompiled code is shown instead.

But you can press Ctr+F8 (or click the button with the white page and brush on it), to reformat the code and to make it more readable again.

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