The SQL syntax for creating a table is:
CREATE TABLE tablename (column def, column def, ...)
To use LabSQL, you use ADO Connection Create, ADO Connection Open (with the DSN of your database), and then SQL Execute. An example might be:
CREATE TABLE UUT_RESULT
( SERIAL_NUMBER TEXT,
LOGIN_NAME TEXT,
DATE_TIME DATETIME,
STATUS TEXT,
ERROR_CODE INTEGER,
ERROR_MESSAGE TEXT
);
The SQL syntax to delete a table is:
DROP TABLE tablename;