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: #schema
http://nedbatchelder.com
Message
From: Ritesh Kapoor [mailto:rkapoor (AT) noida (DOT) atrenta.com]
Sent: Tuesday, 27 December, 2005 4:21 AM
To: sqlite-users (AT) sqlite (DOT) 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?
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. EInfo
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.