title: SQLiteOpenHelper - creating database on SD card
body: <p>in my test android app I intend to create and access database file, which will be located on SD card. I am using main activity with help of a class, which extends SQLiteOpenHelper. I want to use it the same way as before, but I have to somehow change the database PATH. Do you know, how to achieve it?</p>
  
  <p>thx</p>
  
  <p>My current code of a class which extends SQLiteOpenHelper:</p>
  
  <pre><code>public class DatabaseDefinition extends SQLiteOpenHelper{
  private static final String DATABASE_NAME="test.db";
  private static final int DATABASE_VERSION=1;
  
  public DatabaseDefinition(Context context) {
      super(context,DATABASE_NAME,null, DATABASE_VERSION);
  
  }
  
  @Override
  public void onCreate(SQLiteDatabase db) {
      db.execSQL("CREATE TABLE "+TABLE_NAME+" ("+ _ID +" INTEGER PRIMARY KEY AUTOINCREMENT, "+ NAME+" TEXT NOT NULL, " +SURNAME+" TEXT NOT NULL, "+PHONE+" INT NOT NULL);");
  }
  
  @Override
  public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
      db.execSQL("DROP TABLE IF EXISTS" + TABLE_NAME);
      onCreate(db);
  
  }
  </code></pre>
  
  <p>And code of my main:</p>
  
  <pre><code>public class DatabaseExampleActivity extends Activity {
     private DatabaseDefinition database;
     private static String[] FROM={_ID, NAME, SURNAME,PHONE};
     private static String ORDER_BY=" DESC";
  
  
     @Override
     public void onCreate(Bundle savedInstanceState) {
         super.onCreate(savedInstanceState);
         setContentView(R.layout.main);
         database= new DatabaseDefinition(this); 
         try{
           String name = null;
           String surname=null;
           int phone=0;
           addEvent("John", "Black", 111012345);
  
      }finally{
          database.close();
      }
    }
  
  
  
  }
  </code></pre>