SqlLite

1.获取表结构：pragma table_info (表名)

2.获取数据库表表名： select name,'pragma table_info ('||name ||')' pra from sqlite_master where type='table'