主流資料庫自增欄位（Identity/Sequence/Auto_Increment）建立語法完整對照表

CREATE TABLE T1 (
  id INTEGER NOT NULL
    GENERATED ALWAYS AS IDENTITY
    (START WITH 1 INCREMENT BY 1
     MINVALUE 1 NO MAXVALUE NO CYCLE NO CACHE ORDER),
  ...
);

CREATE TABLE T1 (
  id NUMBER(10,0) NOT NULL,
  ...
);
CREATE SEQUENCE T1_ID_SEQ INCREMENT BY 1 START WITH 1 NOMAXVALUE NOCYCLE CACHE 100 ORDER;
CREATE OR REPLACE TRIGGER INSERT_T1_ID
BEFORE INSERT ON T1
REFERENCING NEW AS new OLD AS old
FOR EACH ROW
BEGIN
  SELECT T1_ID_SEQ.NEXTVAL INTO :new.id FROM DUAL;
END;

CREATE TABLE T1 (
  id NUMBER(10) GENERATED ALWAYS AS IDENTITY,
  ...
);

CREATE TABLE T1 (
  id INT NOT NULL AUTO_INCREMENT,
  ...
  PRIMARY KEY (id)
);

CREATE TABLE T1 (
  id SERIAL NOT NULL,
  ...
);
-- 或 10+ 標準語法
CREATE TABLE T1 (
  id INT GENERATED ALWAYS AS IDENTITY PRIMARY KEY,
  ...
);

CREATE TABLE T1 (
  id INT NOT NULL IDENTITY(1,1),
  ...
  PRIMARY KEY (id)
);

CREATE TABLE T1 (
  id INT NOT NULL IDENTITY,
  ...
  PRIMARY KEY (id)
);