[python sqlite3查看數(shù)據(jù)庫所有表(table)]
#coding:utf-8
import sqlite3
'''
sqlite3存在系統(tǒng)表sqlite_master,結(jié)構(gòu)如下：
sqlite_master(
type TEXT, #類型:table-表,index-索引,view-視圖
name TEXT, #名稱:表名,索引名,視圖名
tbl_name TEXT,
rootpage INTEGER,
sql TEXT
)
'''
#查看某數(shù)據(jù)庫中所有表
def GetTables(db_file = 'main.db'):
try:
conn = sqlite3.connect(db_file)
cur = conn.cursor()
cur.execute("select name from sqlite_master where type='table' order by name")
print cur.fetchall()
except sqlite3.Error, e:
print e
'''
#查看表結(jié)構(gòu)
cur.execute("PRAGMA table_info(T_Person)")
print cur.fetchall()
'''
2."describe table"
兩種方法
-
cursor.execute("PRAGMA table_info(tablename)")
print cursor.fetchall()
--
from sqlite3 import dbapi2 as sqlite
cur.execute("SELECT * FROM SomeTable")
col_name_list = [tuple[0] for tuple in cur.description]
