| **Navigation:**  [[welcome to my product .htm|User's Guide and Tutorials]] > The Dictionary > Dictionary Editor >====== Dictionary Editor ====== | [[clarion s support of database design.htm|{{btn_prev_n.gif|Previous page}}]][[welcome to my product .htm|{{btn_home_n.gif|Return to chapter overview}}]][[lesson 1 data import.htm|{{btn_next_n.gif|Next page}}]] |
|  ||

**Overview and Introduction**

The lessons that follow describe the creation and maintenance of database dictionaries. Database dictionaries define the physical layout of the data files to be accessed by an application, the relationships existing between files, and the rules for maintaining these relationships.

Programs that are created with the Application Generator in order to access data files require database dictionaries.

[[lesson 1 data import.htm|Lesson 1 - Data Import]]

In this lesson, see how easy it is to create a dictionary, and examine the different options that you have when importing data definitions.

[[lesson 2 table properties.htm|Lesson 2 - Table Properties]]

Examine the options available for the tables that you import or create in your data dictionary.

[[lesson 3 column properties.htm|Lesson 3 - Column Properties]]

Examine the many options available for each column defined in your dictionary. See how certain settings can help speed up and polish your applications.

[[lesson 4 key and index properties.htm|Lesson 4 - Key and Index Properties]]

Explore the Key and Index options available in you data dictionary. Learn the importance of proper key definitions, and how it can save you time as you develop your applications.

[[lesson 5 adding relationships.htm|Lesson 5 - Adding Relationships]]

Discover the importance of defining proper relationships between the tables defined in your dictionary.

[[lesson 6 trigger properties.htm|Lesson 6 - Trigger Properties]]

Explore the use of Client-Side Triggers, and how you can easily enforce powerful business rules during normal database operations in your applications.

[[lesson 7 sql odbc and ado imports.htm|Lesson 7 - SQL, ODBC, and ADO Imports]]

Discover the deep support of Clarion's data dictionary with SQL, ODBC, and ADO type databases. Examine the Dictionary Synchronizer, a powerful accessory that is built into the environment.

[[lesson 8 advanced features of the dictionary editor.htm|Lesson 8 - Advanced Features of the Dictionary Editor]]

The Dictionary Editor is packed with features and options that can accelerate your planning and development. This lesson explores several key areas.

**Next:** [[lesson 1 data import.htm|Lesson 1 - Data Import]]