Creating a data dictionary

A data dictionary is a document that helps you understand what is in your database. It includes things such as the names of all the objects, tables, and column names, what the data type of each column is, and any constraints on table columns. The data dictionary can also include any notes about the tables you think would be necessary for people to know about the data.

To create a data dictionary in MySQL for free, you will need to install a Python plugin into your MySQL Workbench installation. The Python file you will need for this can be found in the code files you downloaded in the Technical requirements section of this chapter. Follow these steps to install the plugin:

  1. In MySQL Workbench, click Scripting

Get Learn SQL Database Programming now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.