|
Browsing objects structure
You can explore the structure of a table or view
in "explore table" window.
|
|
|
Fig 3: Explore table window
(click for comments)
|
There are two comboboxes in that window. The left one contains the
list of all catalogs and schemas, and the right one
contains the list of tables and views in the currently
selected catalog and/or schema.
You can use it to quickly jump to another object
in the same window.
If you need to explore some objects simultaneously,
just open another "explore table" window.
You can generate CREATE TABLE statement
which creates a table
similar to the table you are exploring. Sometimes, however, generated
script requires manual editing due to possible limitations of ODBC
driver.
Next section
|
