CREATE TABLE "USERID "."GROUPS" (
"NID" INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY ( START WITH +1 , INCREMENT BY +1 , NO CACHE ) ,
"PID" INTEGER NOT NULL WITH DEFAULT 0,
"LVL" INTEGER NOT NULL WITH DEFAULT 0,
"NAME" VARCHAR(30) ,
"REMARK" VARCHAR(30) ,
"DEPARTMENT" VARCHAR(30) )
IN "USERSPACE1" ;