テーブルスキーマ(構造)の確認
1）sqlite_masterテーブルを利用する方法
sqlite> .mode line
sqlite> select * from sqlite_master;
type = table
name = test
tbl_name = test
rootpage = 2
sql = CREATE TABLE test(id, name)
type = table
name = personal
tbl_name = personal
rootpage = 3
sql = CREATE TABLE personal(id, name)
type = table
name = personal2
tbl_name = personal2
rootpage = 4
sql = CREATE TABLE personal2(id integer, name text)
sqlite>
2）.schemaコマンドを使って
sqlite> .schema
CREATE TABLE test(id, name);
CREATE TABLE personal(id, name);
CREATE TABLE personal2(id integer, name text);
sqlite>
