Skip to content

Instantly share code, notes, and snippets.

@rdapaz

rdapaz/temp.sql.md

Created September 21, 2022 03:36
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save rdapaz/4ef3b79d404adfcafdb503e7e376ec70 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save rdapaz/4ef3b79d404adfcafdb503e7e376ec70 to your computer and use it in GitHub Desktop.
Download ZIP
List all column names in sqlite3 database
Raw
temp.sql.md

This is the sql query that does the trick

select * from pragma_table_info('<table_name>') as tblInfo

Don't forget the quotes!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment