Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Product Manuals » ElevateDB Version 2 Manual for RAD Studio XE2 (C++ Win32) » Using ElevateDB » Creating, Altering, or Dropping Database Objects |
// This example uses a database component that // has already been created and opened // called MyDatabase MyDatabase->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 |