Show temporary tables and views in Structure and Browse tabs

Also show temporary tables in the Database Structure and the Browse Data tabs as well as in the export dialogs etc.
wpwen · Jun 7, 2014 · 7139ad0 · 7139ad0
1 parent 8c81877
commit 7139ad0
Showing 1 changed file with 1 addition and 1 deletion.
diff --git a/src/sqlitedb.cpp b/src/sqlitedb.cpp
@@ -765,7 +765,7 @@ void DBBrowserDB::updateSchema( )
     if(!isOpen())
         return;
 
-    QString statement = "SELECT type, name, sql, tbl_name FROM sqlite_master;";
+    QString statement = "SELECT type,name,sql,tbl_name FROM sqlite_master UNION SELECT type,name,sql,tbl_name FROM sqlite_temp_master;";
 
     QByteArray utf8Statement = statement.toUtf8();
     err=sqlite3_prepare_v2(_db, utf8Statement, utf8Statement.length(),