Schema Printing

Previous  Top  Next

( Pro Edition )

 

Printing Schema Objects can be done in different ways - you can use the Print button in the main toolbar and select Print Objects, or use the context menu in the Database Navigator for the Schema node. Before printing, a Print Preview is available.

 

If you using the context menu on a list or a single object in the Database Navigator, you will only get a Print Options dialog. Using the OK button on the dialog will open a preview of the selected object or list of objects.

 

For additional notes, take a look at:

Schema Printing and MySQL

 

The Print Objects option will open the Print Metadata dialog, which looks similar to this:

 

Print Metadata window

 

On the left, there's a list of available objects to print. Depending on what database engine you're using, the toolbar might have more or less buttons enabled. There's a button for each type of schema object - domains, tables, views etc... Note there's no button for Indices - these are getting (optionally) printed with each table.

 

By using the buttons in (1) - you can move items from the left to the right, or vice versa.

 

The options in (2) are different for each object type, and are dependent on the capabilities of your database engine: if your database engine doesn't support "triggers", then an option like include triggers is disabled. Below is an explanation of the different options you will encounter.

 

The two toolbar buttons (3) give you the possibility of showing a preview or printing your report. You can mix any number and/or type of objects - if you're using multiple object types, Database Workbench will automatically create a "multi-report" - a report that is build from the separate reports.

 

A Preview allows you to check if the report is what you want, without wasting any paper - you can browse forward and back in the report pages and there's a Print button as well.

 

Printing Options

Include Description

If an object has a description, it will be printed along with the object.

 

Include DDL

Includes the metadata statement(s) needed to create the object.

 

Include Source

For objects that support source code (like Stored Procedures), the code will be printed if this option is selected.

 

Include Parameters

Include a list of parameters for objects that support it (like Stored Procedures).

 

Include Columns

For tables and views, this will include a list of their columns with datatypes.

 

Include Column Description

If the column has a description, it will be printed along with the column.

 

Include Triggers

For tables and views, this will include the triggers with the object.

 

Include Indices

For tables, this will include the table indices.

 

Include View Source

For views, this will print the view source along with the view information.

 

Include Check Constraint

For domains, this will include the CHECK clause, if used.

 

 

Example Print Preview:

A Print Preview for table ACCOMMODATION