Context Menu & Update Buttons

When you right-click on the Schema Dictionary, you will see this menu:

1. Add - This allows you to add a new column to your Schema Dictionary. Please have a look here for details.
2. Change - This allows you to change/update the currently selected column. Please have a look here for details.
3. Delete - This allows you to delete the currently selected column. Please have a look here for details.
4. Advanced Configuration - This gives you the ability to be able to edit all the tables/columns from one single interface. Please have a look here for more details.
5. Move Down - This repositions the selected field a level lower
6. Move Up - This repositions the selected field a level higher.
7. Show Find Panel - This facilitates efficient field location by enabling the search box functionality.
8. Collapse All - This action will collapse all the columns so that only the tables are shown.
9. Expand All - This action will expand all the items on the Schema Dictionary so that all Tables and columns are shown.
10. Print Schema - This sends a listing of the schema dictionary to your printer.
11. Export To PDF - This exports the schema dictionary to a PDF file.
12. Export To Excel - This exports the schema dictionary to an Excel worksheet.
13. Export To Word - This exports the schema dictionary to a Word document.

 

Different buttons can be used to update the Schema Dictionary and have further actions that you can leverage when you press the dropdown.

1. Add - This allows you to add a new column to your Schema Dictionary. See here for details.
2. [Add] Column - This allows you to add a property to the table you clicked on.
3. [Add] Multiple Columns - This allows you to add many properties to the table without having to manually click the Add button on every addition.
4. [Add] Calculated Columns - 
5. [Add] Table - This allows you to create a new table.
6. Change - This allows you to change/update. See here for details.
7. [Change] Column - This allows you to update a specific column.
8. [Change] Table - This allows you to update a specific table.
9. Delete - This allows you to delete what is selected. See here for details.
10. [Delete] Column - This allows you to delete a column.
11. [Delete] Table - This allows you to delete a table.
12. [Delete] Truncate Schema Dictionary - This will remove the database schema associated with this project.