How to create table in SQLite3

 

Q.54 How to create table in SQLite3.? Ans:-

• Syntax: create table if not exixts table_name (column-def [, column-def]*[,constraint]* note: constraint means give primary key autoinc  etc…
  OR
• Syntax: create table table_name(columnField, columnDataType)
• Query: create table if not exists dummyData(dummyId integer, dummyName text);