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
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
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.