I previously used
Microsoft SQL Server Management Studio and when I right clicked on a table and selected
Select top 1000 rows a new tab would open created.
Inside that tab, some code would be generated automatically and would contain the list of headers (in TSQL syntax) within the select statement:
I really liked this feature because it meant that I didn't have to write out all of the headers every time.
However, when I do this equivlant step (of right clicking on a table and clicking on 'Select Rows - Limit 1000') in
MySQL Workbench 6.3.3, the code that is generated only has the * operator. For example, a new tab would be created and only has this sytax within it:
SELECT * FROM data.table;
The * operator can be used instead of writing all of the column headers but I would like have
MySQL Workbench 6.3.3 generate all of the table headers.
Is it possible to change a
MySQL Workbench 6.3.3 setting so that it performs in the same way as
Microsoft SQL Server Management Studio?