[ES] - Copy column names and types from result set

You can copy the contents of the result set and it will even copy the column names, which is great for moving the result set contents into eg a csv. For documentation purposes, it would be invaluable if there was a quick way to copy the structure (name and type) of the result set.

I guess you mean structure of a dynamic result , not a table or view structure. Am i correct?

Yes, I was referring to the data that could be extracted from the results pane, regardless of how it got there, through a plain ad-hoc query, or running a stored procedure, or whatever else you might do to get a result set.

While not exactly what you described, but very very close... top level Execute menu -> Find Column in Results. From there you can copy to clipboard, save to file, open in Excel with all the data types, and more.

Yes, that could work, but it doesn't because of two significant issues:

1. I cannot copy from there. Neither by Ctrl+c nor using a context menu (the grid in that dialog does not have any). I also cannot select group(s) of columns, only single ones. Neither Ctrl+click nor Shift+click works.
2. That list is ordered alphabetically, which is almost always not in the same order the result set columns are ordered.

By any chance, you are not looking at right-click menu Find Column dialog, are you? The top level Execute menu -> Find Column in Results isn't the same as right-click, it has a different function.

Well, I was. And indeed, they are different. Actually, this is fu... er, I mean funtastic! It does exactly what I need, yet I never knew about this feature. Why did you hide it there?