Hi
CREATE TABLE TABLE_NAME
(
COLUMN1 DATATYPE (OPTIONAL)PRIMARY KEY AUTOINCREMENT NOT NULL,
COLUMN2 DATATYPE (OPTIONAL)NULL,
)
Example:
CREATE TABLE [ORDERS]
(
[ORDER_ID] INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
[ORDER_BY] VARCHAR(50) NULL,
[ORDER_DATE] TIMESTAMP NULL,
[IS_ACTIVE] BOOLEAN NULL
)
This is the sample of create a table u can add as many columns as you can .