![]() ![]() This option generates the documentation in an HTML page. ![]() To export data dictionary select your database, then click the Structure tab and click on the Data dictionary option below the list of tables. PhpMyAdmin allows you to export data dictionary to HTML. Once you provided all the descriptions it is good to export it for more convenient access. Please be careful not to edit any other field as those changes might impact table definition. This action will open a column editor where you can add or edit a comment in the Comments field. To edit column comments select a column by checking the box to the left of its name and click on the Change button. Column comments would be visible in the Comments column in the list of columns. To edit column comments select the table in the sidebar navigation and then go to the Structure tab. To edit comment type in text and click the Go button to save. Comments are visible in Table comments field. To edit table comments select the table in the sidebar navigation and then select the Operations tab. It is great for keeping schema descriptions. MySQL and MariaDB databases allow you to add comments to tables and columns. ![]() If you want your data dictionary to be useful you need to provide explanation for tables and columns. PhpMyAdmin is a very popular free web console for MySQL and MariaDB databases written in PHP. This tutorial will show you how to create a data dictionary for existing MySQL and MariaDB databases with phpMyAdmin - describe tables and columns and export them to a HTML page. ![]()
0 Comments
Leave a Reply. |