>I have tried this but it not works << SELECT name FROM pragma_table_info('Datalogger1') ORDER BY cid >>.
It will NOT WORK unless you have opened a database that has a table named <i>Datalogger1</i> in it.
Suggestion:
1. Start a new SQLite CLI session.
2. Open your database.
3. Run the .tables command
4. Run the SQL statement, taking care to replace <i>Datalogger1</i> by <i>your table name</i>.
If it still <i>does not work</i>, copy your session and paste into a new message in this thread so others can see where you might be going wrong.