To create a table in SQLite, you use the CREATE TABLE statement.

For example, to create a table named ‘users’ with three columns: id, username, and email:

CREATE TABLE users (
id INTEGER PRIMARY KEY,
username TEXT NOT NULL,
email TEXT NOT NULL
);

Leave a Reply

Your email address will not be published. Required fields are marked *