H2 DB

IS_IDENTITY 열의 값이 'YES'인 경우 해당 컬럼이 Auto Increment로 설정된 것으로 간주됩니다.

 

SELECT TABLE_NAME, COLUMN_NAME, IS_IDENTITY
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA = 'PUBLIC'