Use the Content Explorer to browse schema information and data content of all connected data sources. Use the Content Explorer to generate ad hoc queries, which cannot be saved to a file or to the repository. To save generated SQL statements, select and copy the generated query from the Generated Query window.
Use one of these methods to open the Content Explorer:
Select Tools | Content Explorer. The Choose Data Source window displays all the components currently connected to data sources. The names in the list of currently connected databases is a combination of a user-defined name and the generic name of the component type. Select a component and click Start to open the Content Explorer.
Right-click a database component and select Content Explorer.