且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

SQLite,如何获取数据库中的所有表名?

更新时间:2023-01-19 10:37:42

刚刚做了一个快速测试在SQLite Manager插件在FireFox与我使用的SQLite数据库,你使用的查询返回表名。

Just did a quick test in the SQLite Manager plugin in FireFox with the SQLite db i'm working with and the query you're using does return the table names. Are you creating the tables correctly and have you tested the exist to your expectations?

要进行迭代,请执行以下操作:

To iterate through, do something like:

    if (c.moveToFirst())
    {
        while ( !c.isAfterLast() ){
           dirArray.add( c.getString( c.getColumnIndex("name")) );
           c.moveToNext();
        }
    }