select name from sqlite_master where type='table'; There are two sources of info about the database: the sqlite_master table, and the schema pragmas: http://www.sqlite.org/pragma.html#schema
--Ned. http://nedbatchelder.com -----Original Message----- From: Ritesh Kapoor [mailto:[EMAIL PROTECTED] Sent: Tuesday, 27 December, 2005 4:21 AM To: sqlite-users@sqlite.org Subject: [sqlite] How to retrieve names of all the tables in db Hi Is there any function in the sqlite API which would give me the names of all the tables in the DB? Or maybe there is some sql query which does this - please let me know what is the syntax of this query. The problem is that I have a DB which has say 3 tables in it - 1. Employee_Personal_Info 2. Employee_Offical_Info 3. Corporate_Info Is there a way to retrieve the names of the tables assuming that I do have a connection open with the DB. Thanks, Ritesh Kapoor Senior Software Engineer Atrenta Pvt. Ltd.