15.6.3 Create table ¶

(m 'create table-name defs #:if-exists? #f #:primary-keys '() #:engine #f)

• table-name specifies the name of the DB table.

• defs is a list to define the type of columns. For example:

'((name varchar 10) (age integer) (email varchar 20))

• #:if-exists? has two kinds of possible options:
  • ’overwrite and ’drop, which will overwrite the existing table.
  • ’ignore means to ignore the table when it already exists.
• #:primary-keys specifies the primary keys in the created table.

• #:engine specifies the DB engine. It depends on what dbd you chose.