The Data Dictionary lists all database tables and fields within each table. It also includes the field type and field length. This feature is particularly useful to advanced users who are working with SQL queries or reports out of MC Trade.
- Click on the Reports menu and Data Dictionary.
- Click on the drop down list to choose a table.
As you add, each table name will appear in the block underneath the drop down.
You can click the X next to the table name to remove it. If you remove a table, you will need to follow that action by adding another table, so the grid will refresh.
- Repeat step 2 if desired to choose more than one table.
- Click Add.
The fields within the selected tables will appear at the bottom and you may sort by any of the columns.