Tables

Tables are the basic building blocks of a diagram. Every diagram is made up of one or more tables and the various objects related to those tables.

Each table consists of a set of columns that contain information about the type of data stored in the table. Each column must be assigned a name, data type, and length. A table can also have a set of foreign keys, constraints and indexes. Because columns, indexes and triggers are defined for a specific table, they are treated as properties of that table in a database diagram.

With Database Designer for MySQL you can:

• Create new table
• Modify table parameters
• Modify multiple tables at once
• Manage table columns
• Manage table indexes
• Mange Table Triggers

Diagram Objects: Creating a Table | Table Editor | Table Manager | Column Manager | Index Editor

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