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