Adding a Column on onUpgrade in Android followed by a createView might fail

I'm adding a column to a table on the onUpgrade as:

db.execSQL("ALTER TABLE " + LocationOffLine.TABLE_NAME + " ADD 'Reference' TEXT");

after this im calling a

db.execSQL();

to create a view with a CREATE VIEW ... AS Select (...)

but it fails since the added column does not exist. is i just reinstall the app (using the onCreate) the view is created successfully.

Any toughs?