Postgres
MySql
MariaDB
H2
ElasticSearch
SQL Server
Oracle
DB2
SAP Hana
YugabyteDB
SQLite
ClickHouse
Cockroach
NuoDB
Summary
| Platform | Identity | DbArray | DbJson | UUID | History |
|---|---|---|---|---|---|
| H2 | *Identity & Sequence | Partial | Simulated | Native | Triggers |
| Postgres | *Identity & Sequence | Full | Full | Native | Triggers |
| MySql | Identity | Simulated | Full | Triggers | |
| SQL Server 17 | *Sequence & Identity | Simulated | Full | Native | Native |
| SQL Server 16 | *Identity | Simulated | Full | Native | |
| Oracle | *Sequence & Identity | Simulated | Full | Native | |
| DB2 | *Identity & Sequence | None | |||
| SAP Hana | - | - | |||
| SQLite | *Identity | Partial | Simulated | None | |
| ClickHouse | - | - | |||
| Cockroach | - | - | |||
| NuoDB | - | - |