【Python获取SQLite3数据库的表名及字段信息】

记录一波sqlite3代码小实例，上具体代码：

# 获取sqlite3数据库mydb.db中的表名和表字段名

import sqlite3


def sqlite_void():
    conn = sqlite3.connect('d:/data/mydb.db')
    cur = conn.cursor()
    # 获取表名，保存在table_name列表
    cur.execute("select name from sqlite_master where type='table'")
    rows = cur.fetchall()
    table_name = [row[0] for row in rows]

    # 获取表的列名（字段名），保存在col_names列表,每个表的字段名集为一个元组
    col_names = []
    for i in table_name:
        cur.execute('pragma table_info({})'.format(i))
        col_name = cu.fetchall()
        col_name = [x[1] for x in col_name]
        col_name = tuple(col_name)
        col_names.append(col_name)

if __name__ == '__main__':
    sqlite_void()