androidsqliteconsole-application

How to get column names with query data in sqlite3?


I use sqlite3 console to debug my app while it is executing in Android. Is there a way to show also column names (not only data) with data in result of sql query?


Solution

  • Yes, after logged into sql prompt mode, execute the following each at a time:

    .header on
    .mode column