Feature Req: Copy Table/field Names To The Editor

[vygi]

First of all — thank you for the great product, dear Webyoggers! 🙂

Now to my request:

There is one feature I still miss in SQLyog — a possibility to copy (or drag&drop) object (table/field/index/view/SP etc) names to the query editor.

This would be very useful, especially if these names are long and cryptic like “a_subscription_number” or “MonthlyAverage”.

Even now I sometimes click F2 to rename the table, then Ctrl-C to copy name to the clipboard, then Esc co cancel renaming, and then Ctrl-V in the SQL editor window to paste the table name — it still faster if the name is longer than 6-8 characters and you're not a great typer.

One possibility would be to add “Name to clipboard” and/or “Name to query editor” to the Object browsers right-click menu. “Name to clipboard” would copy the object name to the clipboard, and “Name to query editor” would insert the object name into the query editor.

I hope that sumething like this could be possible as other SQL GUIs (MySQL Query Browser or urSQL) are able to do that.

Thank you,

Vygi

[Ritesh]

This option is already in the TO-DO list of SQLyog 😀

[vygi]

hey — great! 😎

is this todo list published somewhere?

(I'm just nosy… it also would prevent duplicated requests)

[Ritesh]

I guess I will need to clean up the TO-DO list and publish it out here. Its just kinda messy now with too many requests 😛

[peterlaursen]

You know that you can copy-paste from OBJECTS pane ?

[vygi]

peterlaursen wrote on Sep 22 2005, 04:32 PM:

You know that you can copy-paste from OBJECTS pane ?

[post=”7273″]<{POST_SNAPBACK}>[/post]

Can I?? No, I think I don't.

At least not field names and nor without clicking F2 to edit a table name, I think.

Or did you mean something different?

[peterlaursen]

What I mean is that if you highlight a table i Object Browser, the create statement for the table is there.

Then mark-up any column-name and copy to clipboard with ctrl-c

Then paste it into editor with ctrl-v

[vygi]

peterlaursen wrote on Sep 22 2005, 04:40 PM:

What I mean is that if you highlight a table i Object Browser, the create statement for the table is there.

Then mark-up any column-name and copy to clipboard with ctrl-c

Then paste it into editor with ctrl-v

[post=”7275″]<{POST_SNAPBACK}>[/post]

Aha!… 😎

Thanks! This workaround is better than mine.

But let's hope that the real solution will come soon.

Regards,

Vygi

[greensweater]

old post, but a good trick I found to copy field names…

select * from [your_table] where false;

then “copy all rows to clipboard,” and in the popup, check “include field names.” Comma-delimited works well for pasting in a query.

[Author]

Posts