The only raw storage of the schema is in the sqlite_master table, where it stores the original text of the create query. But to save yourself from the hell of parsing it all out, pragma table_info(tbl) is the way to go yes. Or the newer version of select from pragma_table_info(tbl)
-----Original Message----- From: sqlite-users [mailto:[email protected]] On Behalf Of Hick Gunter Sent: Thursday, March 01, 2018 9:53 AM To: 'SQLite mailing list' Subject: Re: [sqlite] [EXTERNAL] what internal table contains column names in a table? Pragma table_info -----Ursprüngliche Nachricht----- Von: sqlite-users [mailto:[email protected]] Im Auftrag von mike otwell Gesendet: Donnerstag, 01. März 2018 15:50 An: [email protected] Betreff: [EXTERNAL] [sqlite] what internal table contains column names in a table? I want to write a program that generates insert & update statements for a table. what internal table would I query to get the column names in a table? -- _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users ___________________________________________ Gunter Hick | Software Engineer | Scientific Games International GmbH | Klitschgasse 2-4, A-1130 Vienna | FN 157284 a, HG Wien, DVR: 0430013 | (O) +43 1 80100 - 0 May be privileged. May be confidential. Please delete if not the addressee. _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
