CREATE COLUMN TABLE "SBODEMOPT"."CRD1" ("Address" NVARCHAR(50) NOT NULL , "CardCode" NVARCHAR(15) NOT NULL , "Street" NVARCHAR(100), "Block" NVARCHAR(100), "ZipCode" NVARCHAR(20), "City" NVARCHAR(100), "County" NVARCHAR(100), "Country" NVARCHAR(3), "State" NVARCHAR(3), "UserSign" SMALLINT CS_INT, "LogInstanc" INTEGER CS_INT DEFAULT 0, "ObjType" NVARCHAR(20) DEFAULT '2', "LicTradNum" NVARCHAR(32), "LineNum" INTEGER CS_INT, "TaxCode" NVARCHAR(8), "Building" NCLOB MEMORY THRESHOLD 1000, "AdresType" NVARCHAR(1) DEFAULT 'S' NOT NULL , "Address2" NVARCHAR(50), "Address3" NVARCHAR(50), "AddrType" NVARCHAR(100), "StreetNo" NVARCHAR(100), "AltCrdName" NVARCHAR(100), "AltTaxId" NVARCHAR(32), "TaxOffice" NVARCHAR(50), "GlblLocNum" NVARCHAR(50), "Ntnlty" NVARCHAR(100), "DIOTNat" NVARCHAR(3), "TaaSEnbl" NVARCHAR(1) DEFAULT 'Y', "GSTRegnNo" NVARCHAR(15), "GSTType" INTEGER CS_INT, "CreateDate" LONGDATE CS_LONGDATE, "CreateTS" INTEGER CS_INT, "EncryptIV" NVARCHAR(100), "MYFType" NVARCHAR(2), "VatResDate" LONGDATE CS_LONGDATE, "VatResCode" INTEGER CS_INT, PRIMARY KEY ("CardCode", "Address", "AdresType")) UNLOAD PRIORITY 0  AUTO MERGE 