Create a database

Create a new database for your project.

1. In the Project group, expand the Database node, and double-click on the 4dbx to open it. The Meta-Schema Manager is launched for viewing and modifying the schema.
2. Right-click and select Add Table. Set the table's name property to account. Right-click on the table to add the columns as shown.
   

   Figure 1. Create table

3. Make the id column SERIAL and not null. Make the id column the primary key for the table. With the table selected, right-click to see the menu option for adding a constraint.
   

   Figure 2. Set primary key

4. Save your file.
5. Right-click on the 4dbx file in your project and select Generate Database Creation Script. Select the option to populate database with sample data and then Generate.
   

   Figure 3. Generate Database Creation Script

6. Save the file to the databaseMaintenance sub directory in your project directory to overwrite the default file with your file.
   1. Uncheck the Insert the file in the project option as the file is already in the project; you are just saving the file to disk.
   

   Figure 4. Save to databaseMaintenance sub directory

7. In the project, expand the DatabaseMaintenance group. Right-click on the CreateDatabase program and select Execute. This will compile and run your script, creating and populating the database.