Page 1 of 1
Forum

Welcome to the Tweaking4All community forums!
When participating, please keep the Forum Rules in mind!

Topics for particular software or systems: Start your topic link with the name of the application or system.
For example “MacOS X – Your question“, or “MS Word – Your Tip or Trick“.

Please note that switching to another language when reading a post will not bring you to the same post, in Dutch, as there is no translation for that post!



SQLite - Get all fi...
 
Share:
Notifications
Clear all

[Solved] SQLite - Get all field names of a table

3 Posts
1 Users
0 Reactions
798 Views
 Hans
(@hans)
Famed Member Admin
Joined: 11 years ago
Posts: 2796
Topic starter  

SQLite has some pretty neat features, like this one which retrieves a list of field names (incl. type, not null, default value, etc) or nothing (when the table does not exist):

PRAGMA table_info('tablename');

 

 

Example:


   
ReplyQuote
 Hans
(@hans)
Famed Member Admin
Joined: 11 years ago
Posts: 2796
Topic starter  

Now that I'm playing with this, I did find that you cannot query the rows, unless you do this:

select name from pragma_table_info('tabelname');

😊 


   
ReplyQuote
 Hans
(@hans)
Famed Member Admin
Joined: 11 years ago
Posts: 2796
Topic starter  

Or if you like to see all names in a single string:

select group_concat(name,',') as names from pragma_table_info('tablename');

 


   
ReplyQuote
Share: