Fork me on GitHub
#honeysql
<
2021-08-30
>
quan07:08:18

hi, how can we create add primary key ddl in honeysql? look like there is no add-primary-key helper fn?

ALTER TABLE table_name ADD PRIMARY KEY (id);

seancorfield15:08:01

@quan Use :add-index:

dev=> (-> (h/alter-table :foo)
 #_=>     (h/add-index :primary-key :id)
 #_=>     (sql/format))
["ALTER TABLE foo ADD PRIMARY KEY(id)"]
dev=>