Revisions to How to get a list of column names on Sqlite3 database?

Wasteful complicated query. I made it simplest one according to the question.

edited Mar 24, 2020 at 12:56

I know it is an old thread, but recently I needed the same and found a neat way:

select t.tbl_name,SELECT c.name col_name from sqlite_master t,  FROM pragma_table_info(t.tbl_name'your_table_name') c where t.type = 'table';c;

I know it is an old thread, but recently I needed the same and found a neat way:

select t.tbl_name, c.name col_name from sqlite_master t,   pragma_table_info(t.tbl_name) c where t.type = 'table';

I know it is an old thread, but recently I needed the same and found a neat way:

SELECT c.name FROM pragma_table_info('your_table_name') c;

added 8 characters in body

edited Sep 7, 2019 at 17:24

I know it is an old thread, but recently I needed the same and found a neat way:

select t.tbl_name, c.name col_name from sqlite_master t, pragma_table_info(t.tbl_name) c where t.type = 'table';

select t.tbl_name, c.name col_name from sqlite_master t, pragma_table_info(t.tbl_name) c where t.type = 'table';

I know it is an old thread, but recently I needed the same and found a neat way:

select t.tbl_name, c.name col_name from sqlite_master t, pragma_table_info(t.tbl_name) c where t.type = 'table';

I know it is an old thread, but recently I needed the same and found a neat way:

select t.tbl_name, c.name col_name from sqlite_master t, pragma_table_info(t.tbl_name) c where t.type = 'table';

answered Sep 7, 2019 at 17:01

I know it is an old thread, but recently I needed the same and found a neat way:

select t.tbl_name, c.name col_name from sqlite_master t, pragma_table_info(t.tbl_name) c where t.type = 'table';

Return to Answer