Database Platforms

 

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 - -