Copy/Paste SQL

[BruceHamilton]

I can select portions of text in the history window. The Edit/Copy function in the menu bar is then disabled, but right-click offers “copy to clipboard.” That function, I discover, means “copy the entire history buffer to the clipboard.”

* I recommend changing the contextual menu prompt to something like “Copy buffer to Clipboard.” If not that, then don't allow partial selection in the window.

* What's the recommended procedure for re-executing a previous SQL query?

* Related, is there a way to copy/paste table and column names from the left pane into a query?

[Ritesh]

Quote:

* I recommend changing the contextual menu prompt to something like “Copy buffer to Clipboard.” If not that, then don't allow partial selection in the window.

You can copy partial queries by pressing Ctrl+C

Quote:

What's the recommended procedure for re-executing a previous SQL query?

Paste the above selected text in the SQL window and execute them.

Quote:

Related, is there a way to copy/paste table and column names from the left pane into a query?

No.

There is a workaround though – click on the Table in the ObjectBrowser and its whole structure will be generated in the Objects tab. You can copy table/column names from there.

HTH

[BruceHamilton]

Ctl+C works — thanks!

Note, though, that the three methods of copying produce three different effects. Edit/copy has no effect; right-click ignores the selection and copies the whole buffer; and Ctl-C copies the selected text. This would be more self-documenting (and perhaps more intuitive) if they all did the same thing.

[Ritesh]

Thanks for the suggestion 😀

[Author]

Posts