Oh, thanks!
I've used this query:
SELECT name FROM
(SELECT * FROM sqlite_master UNION ALL
SELECT * FROM sqlite_temp_master)
WHERE type='table' and name!='sqlite_sequence'
and name!='android_metadata'
ORDER BY name;
..and it works perfectly!
On Apr 13, 11:07 am, "Megha Joshi" <[EMAIL PROTECTED]> wrote:
> There isn't really an API to access the list of existing tables in a
> database. You can run a query a special table to find out that info
> using standard SQL. See item 7 athttp://www.sqlite.org/faq.html
>
> On Sat, Apr 12, 2008 at 6:37 AM, Pzikit Bloo <[EMAIL PROTECTED]> wrote:
>
> > Sorry, I mean using Java, not sqlite3 command-line.
> > I'm able to retrieve tables fields but not a db tables list.
>
> > Thanks,
> > Pzikit Bloo
>
> > On 12 Apr, 03:13, "Megha Joshi" <[EMAIL PROTECTED]> wrote:
> > > Hi,
>
> > > Please see the thread below for instructions on how to view tables:
> >http://groups.google.com/group/android-beginners/browse_thread/thread...
>
> > > Thanks,
> > > Megha
>
> > > On Fri, Apr 11, 2008 at 8:58 AM, Pzikit Bloo <[EMAIL PROTECTED]>
> > wrote:
>
> > > > Hi all,
>
> > > > I've several tables within a SQLite database. I need to find the name
> > > > of each tables; how can I do?
>
> > > > Thanks,
> > > > Pzikit Bloo
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google
Groups "Android Beginners" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[EMAIL PROTECTED]
Announcing the new M5 SDK!
http://android-developers.blogspot.com/2008/02/android-sdk-m5-rc14-now-available.html
For more options, visit this group at
http://groups.google.com/group/android-beginners?hl=en
-~----------~----~----~----~------~----~------~--~---
