python查找sqlite3数据库表_python – 搜索Sqlite数据库 – 所有表和列

您可以使用“SELECT name FROM sqlite_master WHERE type =’table’”

找出数据库中表的名称.从那里可以轻松地选择每个表的所有行.

例如：

import sqlite3

import os

filename = ...

with sqlite3.connect(filename) as conn:

conn.row_factory = sqlite3.Row

cursor = conn.cursor()

cursor.execute("SELECT name FROM sqlite_master WHERE type='table'")

for tablerow in cursor.fetchall():

table = tablerow[0]

cursor.execute("SELECT * FROM {t}".format(t = table))

for row in cursor:

for field in row.keys():

print(table, field, row[field])