For example, you want to make an MS SQL database that reflects the business rules in your dictionary. Run the utility template and it generates the needed scripts to create the tables, indices, and constraints in a database. Once generated, simply run the resulting scripts in the SQL Query Analyzer. When done, you have a database populated with empty tables, indices and constraints built in.

You may re-use this template as often as testing of the design requires. Make the changes in the dictionary, and regenerate the scripts. The complete documentation is embedded as comments inside the template. The template used here is the Dct2MSSQL_Russell_B_Eggen utility template. Many thanks to Roberto Artigas for compiling this work.

This class is built on the work originally by Skip Williams and later Mark Goldberg, both of whom still contribute to this work. This version is released under the Clarion Open Source Project.