How would you create a table in SQLite database?

SQLite - Interview Questions

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,    
);