how to show columns in a table sqlite3 code example Example 1: sqlite show table structure sqlite> .schema my_table Example 2: sqlite3 show columns name .schema tablename