That's all you are suppose to get when querying the Master table for table names.
You ask how to get a list of tables. That is what you got. What you are asking for now is more complex. Try: Select Name, SQL from "SQLite_master"; for even more fun try: Select * from "SQLite_master" Fred -----Original Message----- From: [email protected] [mailto:[email protected]]on Behalf Of Gilles Ganault Sent: Thursday, August 13, 2009 3:28 AM To: [email protected] Subject: Re: [sqlite] [Delphi] Reading list of tables? 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 _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
