Difference between revisions of "CREATE TABLE"

// Create customer table with column and table constraints
EXEC SQL
    CREATE TABLE customer
      (ACCOUNT_NO char(5) DESCRIPTION  "Account Code"
      DEFAULT strzero(seqno(),5),
      TITLE char(3) DESCRIPTION "Personal Title",
      LAST_NAME char(16) DESCRIPTION "Customer's Last Name",
      FIRST_NAME char(10) DESCRIPTION "Customer's Given Name",
      INITIAL char(2) DESCRIPTION "Customer's Middle Initial",
      STREET char(25) DESCRIPTION "Street Number and Name",
      CITY char(12) DESCRIPTION "City",
      STATE char(2) DESCRIPTION "State Abbreviation"
      CHECK rlookup(customer.state,state)
      ERROR "Invalid State",
      ZIP char(10) DESCRIPTION "Zip Code",
      LIMIT decimal(11,2) DESCRIPTION "Credit Limit"
      RECALCULATE,
      BALANCE decimal(11,2) DESCRIPTION "Credit Balance"
      RECALCULATE,
      AVAILABLE decimal(11,2) DESCRIPTION "Credit Available"
      CALCULATED limit-balance,
      NOTES LONG VARCHAR DESCRIPTION "Customer Notes",
      START_DATE date DESCRIPTION "Customer Start Date"
      DEFAULT date(),
      ONOPEN "customer");
 
// Specify table format as Visual FoxPro
EXEC SQL
    CREATE TABLE newtable
      (NEWID int AUTOINC,
      NEWNAME char(20))
      TYPE={VFP};
 
// Create table from XML file
EXEC SQL
    SELECT * FROM customer
      SAVE AS XML cust.xml;
 
EXEC SQL
    CREATE TABLE customer2
      FROM XML cust.xml;
 
// Create table from array
set compatible to vfp
use vfptable
afields(array1)
 
EXEC SQL
    CREATE TABLE newtable FROM ARRAY array1;