How to get a list of column names on Sqlite3 database?

by 
PRAGMA table_info(table_name);

will get you a list of all the column names.

More Related Contents:

  1. How can I list the tables in a SQLite database file that was opened with ATTACH?
  2. SQLite INSERT – ON DUPLICATE KEY UPDATE (UPSERT)
  3. Deleting duplicate rows from sqlite database
  4. SQLite – How do you join tables from different databases?
  5. What is the difference between using a cross join and putting a comma between the two tables?
  6. Does SQLite3 not support foreign key constraints?
  7. SQLite – ORDER BY RAND()
  8. Drop all tables command
  9. Core Data Performance with Single Parent Entity
  10. Android multiple databases open
  11. sqlite select with condition on date
  12. SQLite3 UNIQUE constraint failed error
  13. “SELECT *” vs “SELECT ” for performance
  14. Copy table structure to new table in sqlite3
  15. How does database indexing work? [closed]
  16. Declare variable in SQLite and use it
  17. why is null not equal to null false
  18. SQL server query to get the list of columns in a table along with Data types, NOT NULL, and PRIMARY KEY constraints
  19. How do I interpret precision and scale of a number in a database?
  20. Select TOP X (or bottom) percent for numeric values in MySQL
  21. How to select multiple rows filled with constants?
  22. How to select only the first rows for each unique value of a column?
  23. What are the benefits of using database cursor?
  24. What is semi-join in database?
  25. Procedure or function !!! has too many arguments specified
  26. What is it exactly a BLOB in a DBMS context
  27. Composite Primary Keys : Good or Bad?
  28. How to select records without duplicate on just one field in SQL?
  29. Oracle DB: How can I write query ignoring case?
  30. IF() statement alternative in SQLite

Leave a Comment