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 a 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 bcks8a7y3"
(First_Name char(50),
Last_Name char(50),
Address char(50),
City char(50),
Country char(25),
Birth_Date date)