sqlite list columns code example

Example 1: sqlite3 show columns name

.schema tablename

Example 2: sqlite list columns

pragma table_info(table_name)