Object Templates

 Previous  Top  Next

By using object templates, you can be sure you're always using the same structure, or get a head start when creating a new database object that contains source code.

 

The object templates are available for:

•Stored Procedures
•Stored Functions
•Views
•Triggers

 

Each of these templates can be editted in the Template Editor in the Preferences screen - there are templates available per server type.

 

Below is an example Stored Procedure template for InterBase:

 

/*

Procedure:

 

Author   :

Date     :

Purpose  :

Params

------

<param>  : <purpose>

*/

begin

/* code */

end

 

By using templates like this, you can easily create a certain style of coding. From the Template Editor, you can tell Database Workbench to search the files for the templates on a network drive, so that multiple developers can use the same template.