Michael Boldin via alt email wrote:
And for anyone else using python and pysqlite, here is now to get a list of
table
# Python SQLite application
from pysqlite2 import dbapi2 as sqlite
# Connect to database
path= 'C:\\'
dbname= 'dbtest.db'
db_location= path + '\\' + dbname
db = sqlite.connect(db_location)
# Find table names
qx='select tbl_name from sqlite_master'
curs1=db.execute(qx)
qr1=curs1.fetchall()
print qr1
Michael,
That query should be:
select tbl_name from sqlite_master where type='table'
since the sqlite master also holds things like index and trigger
definitions.
HTH
Dennis Cote
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------