Create Table

Tables

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 column is a field that contains a specific piece of information. Much of the power of relational databases comes from defining the relations among the tables.

Create Table

To create a table, right click on the database name in the Object Browser and select the menu option Create Table from the popup menu (or press INS). You can also use main menu: Database -> Create -> Table. This opens up a tab as shown below.

Table name: Specify the name of the table to be created.

Database: Select the name of the database where the table is to be created.

Here you can also change the character set and collation of the table. This is supported only on MySQL versions 4.1 and higher.