How to list the tables names in the Sqlite3 database in Java

Question

I am using sqlite3 database in a java application. How to programmatically get names of all tables in the database? I have tried google and stackoverflow as well, and could NOT find a simple solution as yet. Here is the MySqli code I use with PHP, I am trying a similar approach in Java-Sqlite3

mysqli_select_db($conn, $database);
$res = mysqli_query($conn, "SHOW TABLES FROM " . $database . "");
while($cRow = mysqli_fetch_array($res, MYSQL_NUM)) {

    $namm=$cRow[0];


    $query = "SELECT COUNT(*) FROM " . $namm . "";
    $result = mysqli_query($conn,$query);
    $rows = mysqli_fetch_row($result);
    $namk = $rows[0];

    echo "<li type='square' style='margin-bottom:3px;'>" . $cRow[0] . " (" . $namk . ")</li>";
}
mysqli_close($conn);

SELECT * FROM sqlite_master WHERE ...

Johannes Kuhn
– Johannes Kuhn

2018-06-06 07:06:46 +00:00
Commented Jun 6, 2018 at 7:06 — Johannes Kuhn
– Johannes Kuhn, Commented Jun 6, 2018 at 7:06
Where what? that is the issue.

Padmanabhan
– Padmanabhan

2018-06-07 04:45:50 +00:00
Commented Jun 7, 2018 at 4:45 — Padmanabhan
– Padmanabhan, Commented Jun 7, 2018 at 4:45

Dmitriy Fialkovskiy · Accepted Answer · 2020-11-24 13:00:40Z

8

You could use JDBC's built-in APIs for exploring the database metadata:

try (Connection conn = DriverManager.getConnection("jdbc:sqlite:sample.db")) {
    ResultSet rs = conn.getMetaData().getTables(null, null, null, null));
    while (rs.next()) {
        System.out.println(rs.getString("TABLE_NAME"));
    }
}

edited Nov 24, 2020 at 13:00

Dmitriy Fialkovskiy

3,2558 gold badges36 silver badges49 bronze badges

answered Jun 8, 2018 at 11:08

Mureinik

316k54 gold badges402 silver badges406 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

DEBENDRA DHINDA · Accepted Answer · 2018-06-06 07:23:03Z

1

ArrayList<String> tableNames = new ArrayList<String>();

SqlHelper sqlHelper = new SqlHelper(this, "MYSQLITE.db", null, 1);
SQLiteDatabase sqliteDatabase = sqlHelper.getWritableDatabase();
Cursor cursor = sqliteDatabase.rawQuery("SELECT name FROM sqlite_master WHERE type='table'", null);
while(cursor.moveToNext()){
   String tableName = cursor.getString(0);
   if(tableName.equals("android_metadata")){     
     continue;
   }else{
      tableNames.add(tableName);
   }
 }

answered Jun 6, 2018 at 7:23

DEBENDRA DHINDA

1,1937 silver badges19 bronze badges

1 Comment

Padmanabhan Over a year ago

Thank you for the answer. But this snippet I already have and tried it 2 days back, it threw some error, I don't readily remember. Will try to dig it up and give a try again.

Collectives™ on Stack Overflow

How to list the tables names in the Sqlite3 database in Java

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related