CREATE TABLE userinfo (
Id INTEGER GENERATED BY DEFAULT AS IDENTITY,
Name varchar(100) NOT NULL,
Department varchar(100) NOT NULL,
Status varchar(100) DEFAULT NULL,
Email varchar(200) NOT NULL,
PRIMARY KEY (Id)
)
Hsqldb中设置主键，并让主键自增,布布扣,bubuko.com
原文：http://www.cnblogs.com/tonglingliangyong/p/3840084.html