How to get Data Schema from SQLite.

Get all information from DB:

SELECT * FROM sqlite_master;

Get table name, sql from DB:

SELECT s.tbl_name, s.sql FROM sqlite_master s
where s.type = 'table';


Create table:
CREATE TABLE "sample_blog" (
  "id" INTEGER PRIMARY KEY AUTOINCREMENT,
  "blog_title" varchar(50) NOT NULL,
  "blog_remark" varchar(50),
  "sys_createdate" timestamp DEFAULT CURRENT_TIMESTAMP,
  "sys_updatedate" timestamp
)