SQLite dot commands

[cag8f]

I'd like to use Autoit to return the names of all the tables that exist in an SQLite database, as accomplished when I enter ".tables" at an SQLite command line.  However the simple code:

#include <file.au3>
#include <SQLite.au3>

_SQLite_Startup()

$dbpath = "D:\mydb.db"
$dbhandle = _SQLite_Open($dbpath)

_SQLite_Exec(-1,".tables")

_SQLite_Close()
_SQLite_Shutdown()

encounters an SQLite syntax error in the _SQLite_Exec line.  Can someone explain this to me, or point me to an explanation?  I know the SQLite dot commands behave/function a little differently than other SQLite commands, so I suspect this is related.

I also experience something that is probably related when I use a database management program.  I'm using SQLite Expert in Windows, and cannot get any dot commands (.tables, .help, etc) to work in it either.  

[jchd]

Dot commands are specific to the command-line tool, sqlite3.exe and have nothing to do with SQL.

To list all table names in an SQLite DB, use this in Expert or with _SQLite_GetTable[2D]:

select name from sqlite_master where type = 'table';

[cag8f]

Got it, thanks--that worked.  Is there any Autoit documentation regarding querying the master table?

[jchd]

This is too specific for inclusion in our help file. See here for reference.

[cag8f]

Thanks.