Using Object View

Object View displays different kind of database objects grouped by type. Each bar displays objects of the same type. To find object within the view press Ctrl+F and then start typing. Based on a type of object right click will popup menu with actions you can perform. You can drag and drop objects from Object View to Editor window. To set filter for displayed objects click the filter button on the right edge of pane title bar. Objects from the list can be dragged and dropped on to Quik Diff button.

 

Object View popup menu description

SELECT * For tables and views selects all data
Script CreateScripts object CREATE statement in current or new editor window
Script SelectFor tables and views generates SELECT statement
Script UpdateFor tables and views generates UPDATE statement
Script InsertFor tables and views generates INSERT statement
Script ExecuteFor procedures and functions generates execute statement with template parameters Template Parameters
ExecuteExecutes procedure or function
Script PermissionsGenerates object permissions
DropDrop selected object
Edit Table DataAllows to directly edit table data in Results Grid Table has to have PRIMARY KEY or IDENTITY or UNIQUE KEY
Export Data ToSee Export / Import
Import Data FromSee Export / Import
Add to FavoritesAdds object to Favorites Bar in Object View
Locate in Script Locate CREATE statement for selected object in the active Editor window
Object Search Wildcard search for object in Object View
Scripting OptionsDisplays Scripting Options page
PropertiesDisplays all properties for selected object

Object View Keyboard Shortcuts

Shift + EFavorites
Shift + OSystem Objects
Shift + TTables
Shift + VViews
Shift + SSequences
Shift + PProcedures
Shift + FFunctions
Shift + RTriggers
Shift + KPackages
Shift + NSynonyms