SQL Maestro for MySQL online help
|Prev||Return to chapter overview||Next|
Relational databases store all their data in tables. 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 a column is a field that contains a specific piece of information. Much of the power of relational databases comes from defining the relations among their tables.
The sections below describe each of these actions in detail.
New tables are created within Create Table Wizard. In order to run the wizard you should either
To create a new table with the same properties as one of the existing tables has:
Tables can be edited within Table Editor. In order to run the editor you should either
You can also view and edit table properties without launching Table Editor:
You can change the name of the table using the Rename Table dialog. To open the dialog you should either
Table Editor allows you to work with table data including master-detail views, generate simple SQL statements, and CRUD procedures to work with this table, and split the table into two separate tables.