Sqlite Toolkit - @octave_sqlite/sqlfind

: data = sqlfind (db, pattern)

: data = sqlfind (db, pattern, propertyname, propertyvalue …)

Find information about table types in a database.

Inputs

db

currently open sqlite database.

pattern

Name or pattern to match table in database. Use ” to match match all tables.

propertyname, propertyvalue

property name/value pairs where known properties are:

Catalog

catalog value to match

Schema

schema value to match

Note: currently the property values are not used in the filter process.

Outputs

data

a table containing the query result. Table columns are ’Catalog’, ’Schema’, ’Table’, ’Columns’, ’Type’.

Examples

Show all tables in the database.

 
 # create sql connection to an existing database
 db = sqlite("mytest.db");
 # list all tables
 data = sqlfind(db, '');
 
 

Show information about TestTable

 
 # create sql connection
 db = sqlite("mytest.db");
 # list matching tables
 data = sqlfind(db, 'TestTable');
 
 

See also: sqlite.