Generate Columns Names in MySQL

trafalger Contributor
edited February 17 in Ideas Exchange

Would it be possible to generate a list of columns/ a select statement in the MySQL dataflow - it'd be really nice to not have to type out 30-40 columns when doing a union. 


(Similar to SSMS when you can click "Select top 1000 rows from tablename" and SSMS will generate "Select Col1, Col2, from tablename" and dump it into a new SSMS window. 

1 votes

· Last Updated


  • trafalger
    trafalger Contributor

    PSA - that screenshot is from the default sample "Adventure Works" database so it's all sample data! 

This discussion has been closed.