1. create table Person(rowId integer primary key autoincrement,name text);

2. insert into Person (name) values ('Ansel');

3. .header on

4. .mode column

5.PRAGMA table_info('Person')

log:

cid name type notnull dflt_value pk

---------- ---------- ---------- ---------- ---------- ----------

0 rowId integer 0 1

1 name text 0 0