Tables

Tables are basic database objects for storing data. A table is a data structure consisting of an unordered set of horizontal rows, each containing the same number of vertical columns. The intersection of an individual row and column is a field that contains a specific piece of information.

The list of database tables can be viewed and modified at the Tables Page of the Main Profile Window.

You can create a new table in several ways:

1. Create a new table in Design View by double-clicking at the Create table in design view item on the Tables profile window page.
2. Create a new table using the Table Wizard by double-clicking at the Create table by using wizard item on the Tables profile window page.
3. Create a table using the Import Table Wizard for importing its structure and data from one of the available file formats (Access, Excel, HTML, XML, etc.) by double-clicking at the Create table by importing data item on the Tables profile window page.

To open the existing table for viewing or modifying data, simply double-click at its name on the Tables profile window page.

To change the table structure select its name at the Tables page and click the Design button on the toolbar or in the popup menu. This opens the Table Designer, allowing you to modify table columns, indexes, and options.

To delete a table from the database, select its name at the Tables page and click the Delete button on the toolbar or in the popup menu.

©2004 MicroOLAP Technologies LTD. All Rights Reserved. All trademarks are the sole property of their respective owners.