Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Product Manuals » ElevateDB Version 2 Manual for Lazarus 2.00 (Win32) » Using ElevateDB » Creating, Altering, or Dropping Database Objects |
// This example uses a database component that // has already been created and opened // called MyDatabase with MyDatabase do Execute('CREATE TABLE "Customer" '+ '('+ '"ID" INTEGER GENERATED ALWAYS AS IDENTITY (START WITH 0, INCREMENT BY 1), '+ '"Name" VARCHAR(30) COLLATE "ANSI_CI", '+ '"Address1" VARCHAR(40) COLLATE "ANSI_CI", '+ '"Address2" VARCHAR(40) COLLATE "ANSI_CI", '+ '"City" VARCHAR(30) COLLATE "ANSI_CI", '+ '"State" CHAR(2) COLLATE "ANSI_CI", '+ '"Zip" CHAR(10) COLLATE "ANSI_CI", '+ '"CreatedOn" TIMESTAMP DEFAULT CURRENT_TIMESTAMP, '+ 'CONSTRAINT "ID_PrimaryKey" PRIMARY KEY ("ID"), '+ 'CONSTRAINT "ID_Check" CHECK (ID IS NOT NULL), '+ 'CONSTRAINT "Name_Check" CHECK (Name IS NOT NULL)'+ ')');
This web page was last updated on Thursday, November 16, 2023 at 10:39 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |