Abillity to separate query tab

[expired user #8705]'s profile image [expired user #8705] posted 9 years ago in Feature discussion Permalink
Hi.

I would like to be able to see data/table structure while typing a query. That would spare time to switch between tabs as sometimes we have to type queries for unknown table schemas.

Thanks
ansgar's profile image ansgar posted 9 years ago Permalink
Well I cannot make both tabs visible at the same time without a significant amount of effort and discussion. But you can already expand the "Columns in [tablex]" node in the right handed helper box. There you see the column names plus their data type.

And what you can also do is to use the auto completer. Just use table aliases, then type the alias followed by a dot and see what HeidiSQL proposes you:
1 attachment(s):
  • query-helpers
[expired user #8705]'s profile image [expired user #8705] posted 9 years ago Permalink
Oh that's correct. About the autocompletion, sometimes it doesn't work after hitting "." or there's a quite significant delay. Any clue?

Also, thanks for this awesome piece of software! It's so simple and use and yet so useful :)
ansgar's profile image ansgar posted 9 years ago Permalink
Please watch out for the automatic query in the bottom SQL log window. Probably that's what takes some time.

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