In the object explorer, when I see a list of table names, 99% of the time in my organization we right click, go down to “Generate SQL” and click “Select statement” or some other SQL statement.
Is there a way to change a setting so that when you double click a table it automatically generates a Select statement? Currently when I double click it brings up an “Alter Table” dialog which we never use. Having it generate a Select statement for that table would save a lot of time.
I am not sure whether for double click action, but you can assign a keyborad shortcut:
Go to Menu > Tools > Options
Under Environemnt > Keyboard section
In the middle you see a listbox of modules - expand DatabaseBrowser
Select GenerateSelectStatementAdv
Below there is a textbox labeled as “Assign keyboard shortcut” - enter a shortcut there
Click the Assign button right next to it
OK the window and try it - go to your desired table, press the shortcut (i did CTRL+SHIFT+C) and a new QueryEditor document tab should instantly open with the “select * from db.scheme.tablename” query inside
ps - nice Fallout avatar (=
Not exactly what I had in mind but just as good! I’ve set up keyboard shortcuts for the most common actions I take after selecting a database table. Thank you!