Table Level
Up Database List Connecting . . . Database Level Table Level Column Level Ad-Hoc Query

 

wpe1.jpg (13116 bytes)

Table Level Functions

Listing of columns within a table

Once connected to the selected database, you can left click to drill down and select a table and then left click again to drill down and display the structure (i.e., the columns) of the selected table as shown in the screen shot below.

Each tab in the right panel provides additional detail on the table selected.  The Summary tab provides catalog, schema, name, type, and remarks.   The Definition tab provides column level detail for the table.  The Data tab lists sample rows from the table.  And, finally the SQL Script tab allows you to submit ad-hoc queries to the database.

database_manager_table.jpg (64187 bytes) 

You can also right click on the select table to display and select from the list of table level data discovery or data inspection functions such as count, table sample, etc.

 

 

    

Copyright © 2001- 2002 complementSoft LLC. All Rights Reserved