0

I've already changed the right-click shortcut from SELECT TOP 1000 to Select All, but when it executes the query, it lists out all columns in the query instead of just running SELECT *. Nitpicking here, but it's an extra step when I add a new column and can't just refresh the Select All query that's already up.

Is there any way to make it just SELECT * instead of SELECT [col1], [col2], ...?

Casimir et Hippolyte
  • 88,009
  • 5
  • 94
  • 125
Nick F
  • 72
  • 1
  • 6
  • write and save a select * query. – Dan Bracuk Jul 29 '13 at 15:16
  • @DanBracuk I was hoping I could change the context menu shortcut, but oh well. If that's what it takes, it's probably easier to just do the default Select All and manually change it to a * each time... – Nick F Jul 29 '13 at 15:23

0 Answers0