How can we help you today? How can we help you today?

Column Picker on INSERT Statement

If I key in

INSERT INTO MyTable(

I get the colum the list of columns as suggestions but the Column Picker is not available. Selecting the columns individually is fine when there are only a few columns but not when the table has over 100 columns. Is there something I need to do to get the Column Picker working for this statement?

The Column Picker works fine with a regular SELECT statement.

Thanks

Dave
davegr
0

Comments

2 comments

Sort by
  • Anu D
    Many thanks for your post.

    Column picker is designed to work only with select statement hence it does not work with 'Insert into' statements.

    We appreciate your feedback and hence logged this as a feature request in our internal tracking system whose tracking id is SP-3854.

    It will be reviewed by product manager and than marked for the future release.

    I will update you as soon as it is incorporated.
    Anu D
    0
  • davegr
    Thanks Anu,

    For now I just key in a SELECT statement to get the Column Picker and then after choosing the columns, change the code to an INSERT INTO statement. This at least saves the typing or selection of all the column names one by one.

    I look forward to seeing this functionality added to a future release.

    Regards

    Dave
    davegr
    0

Add comment

Please sign in to leave a comment.