I'm trying to set a primary key consisting of two columns when creating a table in the H2 Database Engine ( link ) , but I did not find the syntax in the manual. Could you give me tips? For example: the syntax in MySql, Postgress ... Maybe some work ...
I've tried:
CREATE TABLE CONTACORRENTE (AGENCIA INT PRIMARY KEY, NUMERO INT PRIMARY KEY)
But H2 does not recognize as a compound key (says that it is not possible to define two primary keys) ...