'How to find information on all columns in a SQLite database?
Searching online, it's pretty easy to find the way to get information on all columns in a SQLite table: use the pragma table_info(name) with the name of the table. But every SQL database I've seen has some way to get this info for all columns for the entire database at once, with some column in the result set linking back to the table that owns the column in question.
Does SQLite support this? Or can it only be done by making a separate query for each individual table?
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|