Selecting an object in the Object Explorer
Published 20 March 2014
You can use SQL Prompt to select an object in the Object Explorer from a query window:
- In a query window, right-click the object you want to script out:
- On the context menu, click Select in Object Explorer.
Alternatively, place the cursor over the object you want to select and press Ctrl + F12.
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.