It`s possible to generate select DDL from table with all columns?

For example I have table with 20 columns and one of them contains unix timestamp. If I want to query all data from this table and want to represent unix timeformat as regular date (YYYY.MM.DD) I should mention all columns in select statement by myself. It takes a lof of time. 

It will be good if I can right click on the table name at Database window and select "Generate -> Select statement" and get select DDL with all columns name.

Or may be I can do this somehow else? 

 

1 comment
Comment actions Permalink

Hi Alexander,

What DDL exactly do you mean? Or do you mean select query, which would enumerate al the columns from the table? There is no such macro. Feel free to create this request in YouTrack: https://youtrack.jetbrains.com/issues/DBE

0

Please sign in to leave a comment.