You can use SQL Prompt to select an object in the Object Explorer from a query window:

1. In a query window, right-click the object you want to script out:
   
2. On the context menu, click Select in Object Explorer.

Supported objects

SQL Prompt can select all objects and columns in the Object Explorer except:

• columns in linked tables
• columns in table-valued functions
• temporary tables
• columns in temporary tables

Selecting a synonym

When you press Ctrl + F12 on a synonym, SQL Prompt selects the synonym's base object in the Object Explorer.

To select the synonym object rather than the base object, press Ctrl + Shift + F12.