How to get a list of column names

by 
SELECT sql FROM sqlite_master
WHERE tbl_name="table_name" AND type="table"

Then parse this value with Reg Exp (it’s easy) which could looks similar to this: [(.*?)]

Alternatively you can use:

PRAGMA table_info(table_name)

More Related Contents:

  1. near “varchar”: syntax error [closed]
  2. How do I make an UPDATE while joining tables on SQLite?
  3. How do I rename a column in a SQLite database table?
  4. How do I check in SQLite whether a table exists?
  5. How to set Sqlite3 to be case insensitive when string comparing?
  6. Escape single quote character for use in an SQLite query
  7. Difference between 2 dates in SQLite
  8. Update with Join in SQLite
  9. Can I read and write to a SQLite database concurrently from multiple connections?
  10. How do I store and retrieve a blob from sqlite?
  11. SQLite error ‘attempt to write a readonly database’ during insert?
  12. Store boolean value in SQLite
  13. Can SQLite support multiple users?
  14. SQLite add Primary Key
  15. Encrypted cookies in Chrome
  16. How delete table inner join with other table in Sqlite?
  17. Export from sqlite to csv using shell script
  18. ALTER TABLE ADD COLUMN IF NOT EXISTS in SQLite
  19. Create table in SQLite only if it doesn’t exist already
  20. How do DATETIME values work in SQLite?
  21. Add ON DELETE CASCADE behavior to an sqlite3 table after it has been created
  22. sqlite get ROWID
  23. How to have an automatic timestamp in SQLite?
  24. svn cleanup: sqlite: database disk image is malformed
  25. SELECT INTO statement in sqlite
  26. How to display blob value using x’abc’ binary string literal syntax?
  27. Unable to load DLL sqlite3 in Universal Windows App running on Mobile
  28. Integration Testing Entity Framework code first with in-memory database
  29. DbFunctions.TruncateTime LINQ equivalent in EF CORE
  30. How to get the number of rows of the selected result from sqlite3?

Leave a Comment