Select all columns

已完成

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.

0

Hi,

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

Thank you

 

1

@vasily That's exactly what I mean :)

0

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

@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

@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

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

请先登录再写评论。