SQLite Schema Information Metadata

by

You’ve basically named the solution in your question.

To get a list of tables (and views), query sqlite_master as in 

SELECT name, sql FROM sqlite_master
WHERE type="table"
ORDER BY name;

(see the SQLite FAQ)

To get information about the columns in a specific table, use PRAGMA table_info(table-name); as explained in the SQLite PRAGMA documentation.

I don’t know of any way to get tablename|columnname returned as the result of a single query. I don’t believe SQLite supports this. Your best bet is probably to use the two methods together to return the information you’re looking for – first get the list of tables using sqlite_master, then loop through them to get their columns using PRAGMA table_info().

More Related Contents:

  1. Accessing an SQLite Database in Swift
  2. How to delete or add column in SQLITE?
  3. Import CSV to SQLite
  4. Select random row from a sqlite table
  5. How to get Top 5 records in SqLite?
  6. Insert new column into table in sqlite?
  7. How do you enable LIMIT for DELETE in SQLite?
  8. Sqlite primary key on multiple columns
  9. How to create custom functions in SQLite
  10. Sqlite group_concat ordering
  11. What is the difference between SQLite integer data types like int, integer, bigint, etc.?
  12. is there a limit to the size of a SQLite database?
  13. How to generate all dates between two dates
  14. SQLITE_BUSY The database file is locked (database is locked) in wicket
  15. Does it matter what extension is used for SQLite database files?
  16. SQLite “INSERT OR REPLACE INTO” vs. “UPDATE … WHERE”
  17. How do I DROP a constraint from a sqlite (3.6.21) table?
  18. Sqlite over a network share [closed]
  19. How do I add a new column in between two columns?
  20. SQLite table constraint – unique on multiple columns
  21. Are there any reserved words in SQLite?
  22. What is the difference between related SQLite data-types like INT, INTEGER, SMALLINT and TINYINT?
  23. Modify a Column’s Type in sqlite3
  24. Case sensitive and insensitive like in SQLite
  25. SQLite accent-insensitive search
  26. How to have an automatic timestamp in SQLite?
  27. SELECT INTO statement in sqlite
  28. How to display blob value using x’abc’ binary string literal syntax?
  29. Unable to load DLL sqlite3 in Universal Windows App running on Mobile
  30. DbFunctions.TruncateTime LINQ equivalent in EF CORE

Leave a Comment