show columns in table sqllite code example

Example 1: sqlite show table structure

sqlite> .schema my_table

Example 2: sqlite show columns in table

PRAGMA table_info(table_name);