Re: [sqlite] How to query the schema in c++

On 27 Mar 2010, at 1:51pm, Greg Bryant wrote: > From any of the various SQLite admin tools, I can type PRAGMA > table_info(mytable) and I get a result set back with everything I need. > > However, when I move this into my code (we use a front-end class on the > built-in MSVC SQL wrapper), puttin

[sqlite] How to query the schema in c++

I'm trying to set up a general db update routine, since the app I'm working on may change the database at any time, by changing a column type, adding or removing a column. Since only one of those things is supported with alter table, I'm just doing a modification of the "make a temp table, copy st