SQLite - Get all field names of a table - Databases

RE: SQLite - Get all field names of a table

Hans — Wed, 13 Mar 2024 12:26:39 +0000

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

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

RE: SQLite - Get all field names of a table

Hans — Wed, 13 Mar 2024 12:24:31 +0000

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');

😊

SQLite - Get all field names of a table

Hans — Wed, 13 Mar 2024 11:28:32 +0000

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:

534