Question

How would you create a table in SQLite database?

Answer 1

CREATE TABLE statement is used to create a table in SQLite database. You have to define the columns and data types of each column while creating the table.

Syntax:

CREATE TABLE database_name.table_name(    

column1 datatype  PRIMARY KEY(one or more columns),    

column2 datatype,    

column3 datatype,    

columnN datatype,    

);