Select all columns

Completed

I would like to see a feature accessible via a table context menu that allows you to copy a select statement for all individual columns to the clipboard.  Such a feature is available in SQLWorkbenchJ and MySQL Workbench, to name two.

If I have overlooked an already existing feature, apologies.

7 comments
Comment actions Permalink

Hi,

Do you mean this feature Table context menu -> Send to SQL editor -> Select All Statements ?

Thank you

 

1
Comment actions Permalink

@vasily That's exactly what I mean :)

0
Comment actions Permalink

Where can I find this in Intellij Ultimate version. 

I could not locate a Table Context Menu nor find an action for Send to SQL Editor.

 

thank you

0
Comment actions Permalink

@Allen S Bandela,

Could you describe the exact action you need?

Is it look like a feature request https://youtrack.jetbrains.com/issue/DBE-2558 ?

0
Comment actions Permalink

@vasily chernov

I found the solution from a comment you made in another post, which is to type Select * from and then use the hint to 'expand to full column list'. I basically needed the full column list in the Select statement so that I don't have to type all the columns.

I needed to use that SQL in R2DBC @Query annotations.

1
Comment actions Permalink

Hi Vasily

I'm sorry I didn't respond to this sooner - this is what I've been using for a little while, and is almost exactly what I was looking for.

Thanks

Ricky

1

Please sign in to leave a comment.