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 =
Michael Boldin via alt email
wrote:
And for anyone else using python and pysqlite, here is now to get a
list of table
# Find table names
qx='select tbl_name from sqlite_master'
You'd want something like
select tbl_name from sqlite_master where type='table';
In addition to tables,
Thanks Igor, this gives me what I need
In fact,
pragma table_info( sqlite_master );
works to give information about what is in the master table view
And for anyone else using python and pysqlite, here is now to get a list of
table
# Python SQLite application
from pysqlite2 import dbapi2
Michael Boldin via alt email
wrote:
Otherwise how can I determine date tables in a database group and
columns in table and their type
select * from sqlite_master;
pragma table_info(tableName);
Igor Tandetnik
-
To
4 matches
Mail list logo