Creating and using a workbook
To
create a workbook, you use the Workbook wizard.
To create a workbook:
- Click File --> New Workbook and
click OK.
- Click Next on the Welcome page.
- Select a data source and
click Next.
- Select database objects to customize your workbook.
- Type the owner name in the Object Owner field
to restrict the objects to those belonging to a single owner.
- Select table relationships.
- Select Include primary and foreign keys to
import a relationship between two tables that have an explicit join
between a primary and foreign key.
- Select Infer relationships between tables to
import a relationship between a table with a primary key and another
table with a column of the same name and data type.
Click Next.
- Select types of functions and click Next.
- Select tables, views, and synonyms and click Next.
- Select procedures and click Finish.
To
delete a workbook, delete its file (workbook.vwb) from your file
system or select it in the Open dialog box and press Delete.
In a workbook, you can use the Workbooks page of the World Manager
to perform the following tasks:
- Remove objects from your workbook (right-click the object and
click Delete.
- Save or rename your workbook (right-click it and click Save or Save As).
- Refresh or import other objects into your workbook (right-click
the workbook and click Refresh or Import).
- Close the workbook (right-click it and click Close).
- Copy the workbook and change its data source (right-click the
workbook and click Duplicate).
- Modify workbook display options (right-click it and click Options).
- View and modify properties for tables and columns (right-click
the object and click Properties).
- Manage table relationships (right-click the table, click Properties,
and then click the Relationships tab).
The following figure shows the World
Manager displaying a workbook.
The Data folder contains tables, views, and synonyms in the workbook.
You can right-click the Data folder and click Remove this node but show contents to remove
the folder, but not its contents, from the workbook.
The Table folder contains columns. You can right-click a table
or column and click Delete to remove it from
the workbook or Properties to view properties and,
for tables, to edit table relationships.
The Types folder contains data types and the Functions folder
contains the functions in the workbook. You can right-click the
Types or Functions folders and click Don't Display This Item to
hide it or Delete to remove it from the workbook.
The QMF Queries folder (not shown) contains QMF queries.
