Application Note for QuNect ODBC for Quick Base

Using a CREATE TABLE statement

To create a table in Quick Base you need to specify which application the table should be created in. Each Quick Base application has an appid associated with it. Read the How to Find the APPID of a Quick Base Application to determine the appid of your application. If you wanted to create a table called CUSTOMERS in the application whose appid was bcks8a7y3 you would use the following SQL statement:

CREATE TABLE "CUSTOMERS bcks8a876"
(First_Name varchar(50),
Last_Name varchar(50),
Address varchar(50),
City varchar(50),
Country varchar(25),
Birth_Date date,
checkboxField bit,
fileattachmentField longVarBinary,
currencyField numeric(16, 2),
numericField double,
dateTimeField datetime,
TimeField time
)