Use the Content Explorer to browse schema information and data content of all connected data sources. Use the Content Explorer only to generate ad hoc queries, which cannot be saved to a file or to the repository. To save generated SQL, select and copy the generated query from the Generated Query window. To open the Generated Query window, select Generated Query from the View menu. Alternatively, use the Generated Query tab to select and copy a query.
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.
