CREATE TABLE "LP_WYL" (
"ID" DECIMAL(17,0) NOT NULL GENERATED ALWAYS AS IDENTITY (
START WITH +1
INCREMENT BY +1
MINVALUE +1
MAXVALUE +99999999999999999
NO CYCLE
CACHE 20
NO ORDER ) ,
"SEND_ID" CHAR(30) NOT NULL ,
"SEND_NAME" CHAR(50) NOT NULL ,
"BANK_NO" CHAR(50) NOT NULL ,
"PRD_NO" CHAR(50) NOT NULL ,
"APEX1" CHAR(50) ,
"APEX2" CHAR(50) ,
"APEX3" CHAR(50) )
;
-- DDL Statements for primary key on Table "LP_WYL"
ALTER TABLE "LP_WYL"
ADD CONSTRAINT "P_KEY1" PRIMARY KEY
("ID");
ALTER TABLE "LP_WYL" ALTER COLUMN "ID" RESTART WITH 180;