Databases
StackOverflow2013
Postsdbo
POWhy I can't see DB structure by SQLite Manager in file explorer
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POWhy I can't see DB structure by SQLite Manager in file explorer
    text
    copied!<p>Why I can't see DB structure by SQLite Manager in file explorer in Eclipse?<br> When I click my DB in file explorer SQLite Manager button is disable.<br> I have to pull a DB out of Eclipse first and open it with SQLite Database Browser.</p> <p>Here is my create DB code: </p> <pre><code>private static final String DB_NAME = "uniDB_"; private static final String Memo_Table = "Memo"; private static final String Memo_ID = "_ID"; private static final String Memo_Name = "MemoName"; private static final String Memo_PW = "MemoPW"; private static final String Main_Type = "MainType"; private static final String Sec_Type = "SecType"; private static final String Main_ID = "MainID"; private static final String Sec_ID = "SecID"; private static final String Text_Table = "Txt"; private static final String Text_Name = "TxtMemoName"; private static final String Pic_Table = "Pic"; private static final String Pic_Name = "PicMemoName"; private static final String MemoDB_CREATE = "Create table Memo (_ID INTEGER PRIMARY KEY AUTOINCREMENT, MemoName TEXT, MemoPW TEXT, MainType TEXT, SecType TEXT, MainID TEXT, SecID TEXT)"; private static final String PicDB_CREATE = "Create table Pic (_ID INTEGER PRIMARY KEY AUTOINCREMENT, PicMemoName TEXT)"; private static final String TxtDB_CREATE = "Create table Txt (_ID INTEGER PRIMARY KEY AUTOINCREMENT, TxtMemoName TEXT)"; ... private static class DatabaseHelper extends SQLiteOpenHelper { public DatabaseHelper(Context context) { super(context, DB_NAME, null , 1); //call constructor's superclass // TODO Auto-generated constructor stub } ... public void onCreate(SQLiteDatabase db) { // TODO Auto-generated method stub db.execSQL(MemoDB_CREATE); db.execSQL(PicDB_CREATE); db.execSQL(TxtDB_CREATE); } } </code></pre> <p>Thank you very much for your help</p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload