columns displayalong with tables in object explorer

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

Hi,

on left side object explorer i am able to see tables only, is it possible to view columns along with tables without selecting tables, reason: suppose i am editing sp and need to check the column name in table or the datatype, so currently i am doing this by opening another instance of heidi sql,

Thanks for developing this wonderful ide for mysql.

[expired user #9501]'s profile image [expired user #9501] posted 8 years ago Permalink

bump.

ansgar's profile image ansgar posted 8 years ago Permalink

No, currently there is no way to display column names below tables in the tree.

One way to check a table's columns is to use the completion proposal, by typing the table name followed by a dot, which shows the columns. You can also trigger that proposal with Ctrl+Space. See attached image.

1 attachment(s):
  • edit-procedure-with-table-columns
[expired user #9501]'s profile image [expired user #9501] posted 8 years ago Permalink

this works,!! when i write insert statement,column names are not autocompleted like in select query.. any workaround?

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