-- *** before: ***
-- a different extension in every dialect
-- MySQL:      ID INT AUTO_INCREMENT
-- MS SQL:     ID INT IDENTITY(1,1)
-- Oracle:     a sequence plus a BEFORE INSERT trigger

-- *** in version 2003: ***
CREATE TABLE city_new (
    ID   INTEGER GENERATED ALWAYS AS IDENTITY PRIMARY KEY,
    Name VARCHAR(35) NOT NULL
)

-- Support: Oracle 12c, PostgreSQL 10 and Firebird 3.0 accept the
-- standard spelling (GENERATED BY DEFAULT AS IDENTITY lets you supply
-- your own value). MS SQL Server keeps its older IDENTITY(1,1), MySQL
-- AUTO_INCREMENT, SQLite INTEGER PRIMARY KEY AUTOINCREMENT and Access
-- the AUTOINCREMENT type.