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" <[EM
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 at http://www.sqlite.org/faq.html
On Sat, Apr 12, 2008 at 6:37 AM, Pzikit Bloo <[EMAIL PROTECTED]> wrote:
>
> Sorry, I mean usi
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
Hi,
Please see the thread below for instructions on how to view tables:
http://groups.google.com/group/android-beginners/browse_thread/thread/19e867c74a745c94/5571680a18e90e8d
Thanks,
Megha
On Fri, Apr 11, 2008 at 8:58 AM, Pzikit Bloo <[EMAIL PROTECTED]> wrote:
>
> Hi all,
>
> I've several table
4 matches
Mail list logo