Some examples of tcl and sqlite usage:

NOTE: the name of the database is opendb

 * Retrieve the names of the tables stored in a sqlite database:

set tableNames [opendb eval {SELECT tbl_name FROM sqlite_master}]


* Retrieve the names of the columns (variable columnName):

opendb eval "SELECT * FROM nuno LIMIT 1" x {set columnName $x(*)} 

[jnc] You can also use the `PRAGMA` statement `table_info(table_name`) to retrieve column information. See http://sqlite.org/pragma.html for a list of all `PRAGMA` statements.

* Retrieve the row data from a table


<<categories>>Enter Category Here