How can I get the list of a columns in a table for a SQLite database?

by

What you’re looking for is called the data dictionary. In sqlite a list of all tables can be found by querying sqlite_master table (or view?)

sqlite> create table people (first_name varchar, last_name varchar, email_address varchar);
sqlite> select * from sqlite_master;
table|people|people|2|CREATE TABLE people (first_name varchar, last_name varchar, email_address varchar)

To get column information you can use the pragma table_info(table_name) statement:

sqlite> pragma table_info(people);
0|first_name|varchar|0||0
1|last_name|varchar|0||0
2|email_address|varchar|0||0

For more information on the pragma statements, see the documentation.

More Related Contents:

  1. How does Rust implement reflection?
  2. How to have Java method return generic list of any type?
  3. Getting method parameter names
  4. Scala: How do I dynamically instantiate an object and invoke a method using reflection?
  5. How do I check if a given value is a generic list?
  6. Go reflection with interface embedded in struct – how to detect “real” functions?
  7. How do I call a Scala Object method using reflection?
  8. How to get type of the module in F#
  9. Python and SQLite: insert into table
  10. How to get function parameter names/values dynamically?
  11. SQLite Reset Primary Key Field
  12. Determining if an Object is of primitive type
  13. python : list index out of range error while iteratively popping elements
  14. Insert an element at a specific index in a list and return the updated list
  15. How can I get a list of all classes within current module in Python?
  16. How can I access a folder inside of a resource folder from inside my jar File?
  17. Reflection generic get field value
  18. How can I merge many SQLite databases?
  19. Python insert numpy array into sqlite3 database
  20. How can I solve error gypgyp ERR!ERR! find VSfind VS msvs_version not set from command line or npm config?
  21. Reconstruct / get source code of a PHP function
  22. Move an item inside a list?
  23. How to create a list with the characters of a string? [duplicate]
  24. problem about sqlite database, no such table:
  25. Retrieve only static fields declared in Java class
  26. How to auto create database on first run?
  27. How to replace elements in a list using dictionary lookup
  28. Convert List to Pandas Dataframe Column
  29. Cast Object to Generic List
  30. Python: Random numbers into a list

Leave a Comment