Application Note for QuNect ODBC for QuickBase

Using a CREATE TABLE statement

To create a table in QuickBase you need to specify which application the table should be created in. Each QuickBase application has an appid associated with it. Read the How to Find the APPID of a QuickBase 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
)