|
|
 |
Blogs
Toad and Database Commentaries |
Toad World blogs are a mix of insightful how-tos from Quest experts as well as their commentary on experiences with new database technologies. Have some views of your own to share? Post your comments! Note: Comments are restricted to registered Toad World users.
 Do you have a topic that you'd like discussed? We'd love to hear from you. Send us your idea for a blog topic.
|
|
|
|
|
|
Location: Blogs
Ben Boise's Blog
|
|
| BBoise |
6/7/2009 |
|
Where are my objects?
 |
The list of objects, for the active database connection, can be found in the Object Explorer tab of the Navigation Manager window. To activate the Navigation Manager window, simply select View | Navigation Manager from the Toad for Data Analysts menus. This will load as a fly-out window that you can then mouse over and pin (this process should be familiar by now). The bottom half of this window contains the Object Explorer tab:
*Please note that in this screenshot, I also have the Project Manager window open so I have two tabs showing: one for the Object Explorer and one for the Project Manager. You activate the Project Manager window from the View menu.
|
 |
The Object Explorer contains a list of objects for the active database connection. You’ll notice that I have selected the ORCL (QUEST_DEV) connection in the Navigation Manager, so I’m seeing the objects for that connection. If I switch to my Toad Sample Database Access connection, my Object Explorer updates with the list of objects for that connection.
Think of the Object Explorer as the Left Hand Side (LHS) of the Schema Browser in Toad for Oracle. You still have the right-mouse click functionality available on the objects, just as you do in Toad for Oracle. Simply right-mouse click on the object of interest to view these options.
|
You can also view the objects grouped in different ways:
These are similar groupings to what you have in Toad for Oracle.
Now that you’ve found the LHS of the Schema Browser’s equivalent in Toad for Data Analysts, what about the Right-Hand Side (RHS)? This is known as the Database Explorer in Toad for Data Analysts. You can activate the Database Explorer by selecting Tools | Database Explorer from the menu.
The combined behavior of the Object Explorer and Database Explorer is very similar to the Schema Browser in Toad for Oracle. When an object is selected from the Object Explorer, the Database Explorer will refresh to display the details of the selected object:
Each of the tabs in the Database Explorer presents different information about the object, just like the tabs on the RHS of Toad for Oracle’s Schema Browser.
Hopefully, you’re now comfortable with locating objects, performing operations on them and discovering their details in Toad for Data Analysts. Next time, I’ll be discussing the Query Builder and the Editor in Toad for Data Analysts.
Have fun! |
|
| Permalink |
Trackback |
|
|
|
|
|
|
|
|
|