Creating a Table in Table Editor

In this example we will create a new table that does not contain any data. Nevertheless, while creating the table you must decide what types of data you want to store in it. The data is held in fields, and each field can be declared as one of the data types that are available.

The HR database contains the EMPLOYEES table. We are going to create a table that will store employees’ biographies.

To create a table:

  1. You must be connected to a database. For more information about how to create a server connection see How To: Connect to a Database.
  2. In the Database Explorer, double-click a required database wherein you need to create a table.

  3. Right-click the Tables folder and select the New Table icon. The Table Editor opens.

    New Table

  4. In the Name text box, enter a table name. You can give it a name such as ‘employees_biographies’.
  5. In the grid below, click the first empty cell and enter the column name. You can give it a name such as ‘id’. Then press ENTER. Notice, that the data type for that column is defined automatically. Select the check box next to id, in order to set this column as the primary key.
  6. Click next empty cell and enter the column name. You can give it a name such as ‘biography’. Press ENTER. Notice, that the data type for that column is defined automatically.

  7. Click Update Database.

    New Table Edit Window

The new empty table is created. It now appears in the Database Explorer in the Tables folder.