PRAGMA table_info(table_name);
see also:
How to get column names from Sql Server table
How to get column names from DB2 table
How to get column names from Oracle table
How to get column names from Mysql table
How to get column names from PostgreSQL table
Some SQLite tools you can try: https://www.withdata.com/sqlite/