CREATE COLUMN TABLE "IMCYC"."OUDO" ("Code" NVARCHAR(20) NOT NULL , "Name" NVARCHAR(100), "TableName" NVARCHAR(19) NOT NULL , "LogTable" NVARCHAR(19), "TYPE" CHAR(1) CS_FIXEDSTRING DEFAULT '1', "MngSeries" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "CanDelete" CHAR(1) CS_FIXEDSTRING DEFAULT 'Y', "CanClose" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "CanCancel" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "ExtName" NVARCHAR(254), "CanFind" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "CanYrTrnsf" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "CanDefForm" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "CanLog" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "OvrWrtDll" CHAR(1) CS_FIXEDSTRING DEFAULT 'Y', "UIDFormat" CHAR(1) CS_FIXEDSTRING DEFAULT 'Y', "CanArchive" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "MenuItem" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "MenuCapt" NVARCHAR(254), "FatherMenu" INTEGER CS_INT, "Position" SMALLINT CS_INT, "CanNewForm" CHAR(1) CS_FIXEDSTRING DEFAULT 'Y', "IsRebuild" CHAR(1) CS_FIXEDSTRING DEFAULT 'Y', "NewFormSrf" NCLOB MEMORY THRESHOLD 1000, "MenuUid" NVARCHAR(32), "LstUpdDate" LONGDATE CS_LONGDATE, "LstUpdTime" INTEGER CS_INT, "CanApprove" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "TemplateID" INTEGER CS_INT, PRIMARY KEY ("Code")) UNLOAD PRIORITY 5  AUTO MERGE ;
CREATE UNIQUE INDEX "OUDO_TABLE" ON "IMCYC"."OUDO" ( "TableName" ASC )