Menu

Creating table in SQLite3



How to create table in SQLite3


  • 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);
For More Information Please Visit



No comments:

Post a Comment

Related Posts Plugin for WordPress, Blogger...