Step: Create Table

To create a table you can use CREATE TABLE expression where you can define all columns with their types, constraints, and indexes.

For example, this is how you could create a table 'customers'.

CREATE TABLE customers (
  id INTEGER PRIMARY KEY,
  name VARCHAR(50) NOT NULL,
  email VARCHAR(50) NOT NULL,
  countryCode VARCHAR(2) NOT NULL
)

Now, try it for yourself. Let's create table customers