Home Tutorial: Creating a simple database design

# Adding a field to the table

Next we're going to add some fields to this table. Fields normally have the name id when created. Fields have to have unique names so SQLEditor will automatically rename fields by adding a number (id_1, id_2, id_3, etc)

1. Select the books table by clicking on the colored title bar at the top
2. Click the Add Field button in the toolbar
3. A new field will appear in the table
4. Click on the field to select it
5. Then move to the inspector on click once in the Name: field where it says id.
6. rename the field to book_id
7. The look at the Type: popup box. Select the type INTEGER from the popup. (It may already be selected)

← Previous Step
Next Step →