Hello! INT GENERATED BY DEFAULT AS IDENTITY should be used for identity column of INT (INTEGER) data type. Additional NOT NULL clause isn't needed, but may be specified. H2 intentionally supports this standard-compliant syntax in all compatibility modes to have possibility to use the same syntax in all of them.
INT IDENTITY is a syntax from SQL Server, H2 supports it only in MSSQLSERVER and LEGACY compatibility modes. You can't use in in any other mode. https://h2database.com/html/features.html#compatibility LEGAGY mode is based on REGULAR modes, but it is less restrictive and provides better compatibility with H2 1.4.200. You can use it if you can't change definition of your table. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/852e6d79-dae1-4009-945a-4c583e964044n%40googlegroups.com.
