How to Work with a Local Database > Working with Tables

Overview

You can alter the structure/properties of the table(s) you have created. This, however, implies the loss of the data you have already entered.

To Edit the Structure of a Table

Step-by-step

1. Open the "Local Database" module.

2. In the "Tables" section, right-click the table with the structure you want to edit.

3. Click "Edit" to open the selected table's properties window.

4. Edit the following fields, as required:

Table Settings
Name	Maintain or modify the table's name.
Fields
Name	Maintain or enter a new name for the required field(s)
Type	Maintain or select another data type.
Default	Maintain, remove or enter a new default value.
Primary Key	Maintain or check/uncheck the required fields as primary keys.
Auto-Increment	Maintain or check/uncheck the required fields to enable/disable the automatic increment.
Options
Keep Data content when Deploying	Maintain or check/uncheck the option regarding table content. Checking this option ensures that the data contained in the current table, and not just its structure, will be delivered with the project, if you upload it onto a device, use MCL-Simulator or MCL-Tracer to test/analyze the project.

5. If required, click to add more fields or to delete the selected field.

6. If you want to, click (on the window's upper right corner) to open the "Edit/View Data" window and view/edit the data contained in the selected table.

7. Click to apply your modifications.

8. Confirm the editing operation.