I created a new database by using the command line binary on Suse. After activating headers by using .headers ON it still looks messy when getting table information with PRAGMA table_info(TABLE1);:


How can I achieve a cleaner look like this:

sqlite> pragma table_info(member);
cid      name          type     notnull  dflt_value  pk     
-------  ------------  -------  -------  ----------  -------
0        account_id    text     1                    0      
1        account_name  text     1                    0      
  • You could try using one of the available GUI tools - the whole point of SQLite is the "Lite" part - using a GUI tool could allow you to have a pleasant UX while retaining SQLite's lean and mean nature.
    – Vérace
    May 8, 2018 at 15:10

1 Answer 1


In the sqlite3 command-line shell, this output format can be selected with .mode column.


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.