To verify whether this is good for you before buying SQLite Magic PRO you can try free version SQLite Magic.
This applications allows you view/modify data and structure of SQLite Database on Android. Create and modify structure of tables, views, indexes, triggers, table’s constraints and foreign keys in SQLite database, edit and delete records in SQLite database. This application does not support root access.
In more detail using this application user can:
-create, modify, delete, rename, dump tables,
-display tables’ s and views’s data in scrollable grid,
-create, modify, delete, export records,
-support multiselect on records,
-sort and filter records on any field value,
-export filtered data to CSV files (included custom separators),
-create, modify, delete columns in table (including columns’s constraints and foreign keys),
-create, modify, delete table’s constraints (including foreign keys),
-create, modify, delete table’s indexes,
-create, modify, delete table’s triggers,
-create, modify, delete views,
-execute SQL scripts,
-export database to SQL script,
-restore database from SQL script,
-store executed statements to history,
-browse and edit databases on SD card,
-scan SD card for existing databases,
-configurable application’s size,
-remember recently opened databases.