Skip to content
← SQL Prompt

How can we improve SQL Prompt?

SQL Prompt

Categories

JUMP TO ANOTHER FORUM

(thinking…)

Have column selector available on insert statements

I noticed as a new user that when I type in INSERT INTO [table_name] ( column1, etc) that the column selector option is grayed out. When building insert statements that use a select to provide the data being inserted I have to manually select each column. Could you enable column picker in an insert statement?

5 votes

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close

We’ll send you updates on this idea

sheldonhull shared this idea  ·   ·  Report…  ·  Admin →
How important is this to you?

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • Anonymous commented  ·   ·  Report

    I too find this annoying. Dan's workaround is fine but shouldn't be needed. Let's get this one to the top of the vote list!

  • Dan Plaskon commented  ·   ·  Report

    Yes please...currently I have to restort to writing a select statement and using the column picker - I then copy and paste this into my insert statement....so annoying!