On Tue, 11 Aug 2009 11:35:16 +0100, Simon Slavin
<[email protected]> wrote:
>SELECT sql FROM sqlite_master WHERE type='table'

Thanks Simon.

To get only the name of the tables instead of the SQL command that was
used to create them:

SELECT tbl_name FROM sqlite_master WHERE type="table"';

_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to