Looking at the MCL-Designer V4 Work Area > The Project Modules Area

The Local Database module manages the local database tables created within MCL-Designer V4. You can create tables, add data to them, view, edit and index their content.

Detail of the Local Database module

This is the display of an empty "Local Database" module - only the "Tables" section is available.

Once you add a table to the default "Tables" section, the module will display the following sections:

Tables - This section displays the tables you create.

Views - This section displays the views you create.

Indexes - This section displays the indexes you create.

To Add a Table, a View or an Index to the Corresponding Section

Right-click the required section to add a Table, a View and/or an Index. The new elements are displayed in a tree view below the corresponding section.

Remember that the "Views" and "indexes" sections are only available after the creation of a table in the "Tables" section.

If you right-click an added table,you have access to the following options:

	Edit	Opens the selected table's properties window to edit the table.
	Delete	Deletes the selected table.
	Edit/View Data	Opens a window that displays the table's content so you can edit it.

If you right-click an added view, you access these options:

	Edit	Opens the selected view's properties window to edit the view.
	Delete	Deletes the selected view.
	View Data	Opens a window that displays the view's content so you can edit it.

Right-clicking an added index opens the following menu:

	Edit	Opens the properties window of the selected index so you can edit it.
	Delete	Deletes the selected index.

For more information on these options, see:

Working with Tables

Working with Views

Working with Indexes