sqlite查询数据库中存在的所有表

发布时间：2020-12-12 23:35:26 所属栏目：百科来源：网络整理

导读：From within a C/C++ program (or a script using Tcl/Ruby/Perl/Python bindings) you can get access to table and index names by doing a SELECT on a special table named " SQLITE_MASTER ". Every SQLite database has an SQLITE_MASTER table that d

From within a C/C++ program (or a script using Tcl/Ruby/Perl/Python bindings) you can get access to table and index names by doing a SELECT on a special table named "SQLITE_MASTER ". Every SQLite database has an SQLITE_MASTER table that defines the schema for the database.

SQL code

   
   
    
    
    
    SELECT  name  FROM  sqlite_master
  WHERE  type = ' table ' 
  ORDER   BY  name;

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!