Or to see all tables ending with the string "ers", I'd use this list command:Īs a brief summary, if you needed to see how to create a list of SQLite tables, I hope these examples are helpful. To limit the output to show only the tables beginning with the string "order", I use this command:
For instance, in my sample database I see the following tables when I issue the SQLite tables command:Ĭoffees customers order_items orders salespeople The SQLite list tables command lists all the tables by default, but if you have a large database, and just want to see a subset of the tables in the database, you can pass the tables command the equivalent of a SQL LIKE statement. To generate a SQLite tables list, just log into your SQLite database with the sqlite3 command, and then issue the "tables" dot command:Īs you can see, the tables list command begins with a dot (decimal), and you don't need a semi-colon at the end of the command. SQLite FAQ: How do I list the tables in a SQLite database? timeout MS Try opening locked tables for MS milliseconds If TABLE specified, only list tables matching schema tablename Print the entire table: SELECT FROM tablename List all of the. show Show the current values for various settings separator STRING Change separator used by output mode and. If TABLE specified, only show tables matching schema ?TABLE? Show the CREATE statements restore ?DB? FILE Restore content of DB (default "main") from FILE prompt MAIN CONTINUE Replace the standard prompts nullvalue STRING Print STRING in place of NULL values mode MODE ?TABLE? Set output mode where MODE is one of:Ĭolumn Left-aligned columns. load FILE ?ENTRY? Load an extension library If TABLE specified, only show indices for tables indices ?TABLE? Show names of all indices import FILE TABLE Import data from FILE into TABLE SQLiteDatabase database getBaseContext (). I manage to get this, but I also get temporary table names like androidmetadata and sqlitesequence. header(s) ON|OFF Turn display of headers on or off I am trying to get a list of table names from an SQLite database.
explain ?ON|OFF? Turn output mode suitable for EXPLAIN on or off. If TABLE specified, only dump tables matching databases List names and files of attached databases bail ON|OFF Stop after hitting an error. if you are running the sqlite3 command-line access program you can type. backup ?DB? FILE Backup DB (default "main") to FILE For your convenience, here is that sqlite help output: On a related note, when you're using the SQLite command line tool (sqlite3), you can type ".help" to get a list of sqlite commands you can issue. i'm now back at my regular command line: show the schema of the 'projects' table:ĬREATE TABLE projects ( id integer primary key autoincrement, name text not null, type text not null, description text ) # sqlite3 data/data//databases/fptracker.db in this case my database is named fptracker: use the sqlite3 command to connect to your database. Here's an example of how this works, with comments shown before each command:
#ANDROID SQLITE LIST TABLES ANDROID#
You can show a list of SQLite tables by starting the Android adb shell (command line tool), and then properly invoking the sqlite3 command. By default, SQLite is embedded in android, thus there is no need to perform any database setup or administration task. Android/SQLite FAQ: How do I show a list of SQLite database tables from the Android command line (adb shell)?
0 kommentar(er)
