If the database was created by you, shouldn't you already know which tables
are in it?
On Tue, Jul 28, 2009 at 6:18 PM, guishenl...@gmail.com <
guishenl...@gmail.com> wrote:
>
> I want to get the tables programmatically not in the command line. And
> the database is created by myself not the contact database. Could you
> give me some example code?
> Thank you very much in advance!
>
> On 7月28日, 下午9时46分, "Yusuf T. Mobile" <yusuf.s...@t-mobile.com> wrote:
> > It depends if you want all the tables programmatically or if you can
> > do it in the command line. Sujay's answer was from the command line.
> > So starting a few steps back, you type:
> >
> > > adb shell
> >
> > # cd /data/data
> > # cd com.android.providers.contacts
> > # cd databases
> > # sqlite3 contacts.db
> > SQLite version 3.5.9
> > Enter ".help" for instructions
> > sqlite> .tables
> >
> > That will get you all the tables in the contacts database, for
> > example. If that doesn't answer your question, let me know more about
> > what you need and I'll try to help.
> >
> > Yusuf Saib
> > Android
> > ·T· · ·Mobile· stick together
> > The views, opinions and statements in this email are those of the
> > author solely in their individual capacity, and do not necessarily
> > represent those of T-Mobile USA, Inc.
> >
> > On Jul 28, 12:59 am, "guishenl...@gmail.com" <guishenl...@gmail.com>
> > wrote:
> >
> >
> >
> > > Thank you for answering!
> > > But I didn't catch your real meaning.
> > > Could you give me some exact code to show your point?
> >
> > > On 7月28日, 下午3时25分, Sujay Krishna Suresh <sujay.coold...@gmail.com>
> > > wrote:
> >
> > > > .tables is the sql instruction to retrieve all the tables in the db.
> > > > try executing it asa sql statement with rawQuery.
> >
> > > > On Tue, Jul 28, 2009 at 12:45 PM, guishenl...@gmail.com <
> >
> > > > guishenl...@gmail.com> wrote:
> >
> > > > > Hi all,
> > > > > I'm working at an application about SQLite database. I have
> > > > > inserted some table in an database file. But I don't know how to
> get
> > > > > all the tables' name using code. For example, I defined a database
> > > > > object
> > > > > SQLiteDatabase dataBase = SQLiteDatabase.openOrCreateDatabase(
> > > > > getDatabasePath("Mydatabase"), null);
> > > > > and how can I get all the table names stored in the database file
> > > > > "Mydatabase". Counld anyone give me some code to help me?
> > > > > Thank you in advance!
> >
> > > > --
> > > > Regards,
> > > > Sujay
> > > > Joan Crawford<
> http://www.brainyquote.com/quotes/authors/j/joan_crawford.html>
> > > > - "I, Joan Crawford, I believe in the dollar. Everything I earn, I
> > > > spend."- 隐藏被引用文字 -
> >
> > - 显示引用的文字 -
> >
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google
Groups "Android Developers" group.
To post to this group, send email to android-developers@googlegroups.com
To unsubscribe from this group, send email to
android-developers-unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en
-~----------~----~----~----~------~----~------~--~---
