Highlight a SELECT stmt and create a temp table definition from it. You often need to create #tables and you have a select to fill it with. However, you have to either create the #table manually or do a SELECT INTO into a real table and then script it out. It would be nice to be able to just take my SELECT and be able to get the #table definition for it.

When I hover over an object and get the pop-up script for that object (proc/view/function) I would like the ability to have the script default to ALTER instead of CREATE.

99.9% of the time I manually have to edit the Create to be an Alter, this would save SO MUCH time.

F12 works great for viewing the definition of a procedure. How about doing the same trick for a table/view. i.e. highlight a table, press F12, and see the CREATE TABLE script for that table.

It would be nice to highlight an object in the Object Explorer, hit F12, and have the ALTER script in a new tab already named appropriately.

Similar to Resharper's 'goto type' - a keyboard shortcut is used to bring up a search box. This then suggests objects from the database based on partial matching of the input. On selection of an object, a script-as-alter query window is opened for the object.

When I point on the object in editor it generates the script for that object. It would be nice to have some kind of dropdown list with checkboxes or something like that to add some extra conditions what objects to generate. For example for table it generates: table code, constrains, indexes... Sometimes I want to see there triggers, maybe permissions, something else.

I often want to open a procedure that is inside dynamic sql or in a list of objects. Today I have to put an EXEC in front of statement. F12 ought to be able to find the proc/function/view anyway.

I like how I can use 'ap' and a stored procedure name to quickly edit a stored procedure, without having to use the solution explorer to find it and right click etc.
It's a bigger ask, but I'd like a shortcut I can also use to open a table up in designer view. Something like 'at' and then intellisense the table name, and then when I hit tab, it opens the table up in design view.

Often when working on a database object will type exec procname/select * from view/table. When the desired object is selected with arrow keys a Sourcebox popup appears with a Copy button. A shortcut key to this button would be fantastic. Fingers on keyboard instead of finding mouse.

My colleagues and I often script out views and this requires four clicks (its not a lot but we do this many many times a week). Like Stored Procs can we have a top level Create or Alter command instead? This way its just a right click left click and no sliding around the menu.

When auto-generating source for ALTER PROCEDURE, make sure to replicate the original options settings. For example, generate a "SET QUOTED_IDENTIFIER OFF" if the procedure originally had this setting.