sqlite> create table people (first_name varchar,last_name varchar,email_address varchar);
sqlite> select * from sqlite_master;
table|people|people|2|CREATE TABLE people (first_name varchar,email_address varchar)

要获取列信息，可以使用pragma table_info(table_name)语句：

sqlite> pragma table_info(people);
0|first_name|varchar|0||0
1|last_name|varchar|0||0
2|email_address|varchar|0||0

有关pragma语句的更多信息，请参阅documentation。