[Tutor] sqlite: does "?" work in PRAGMA commands?

John Fouhy john at fouhy.net
Fri Aug 3 00:07:58 CEST 2007


On 03/08/07, Terry Carroll <carroll at tjc.com> wrote:
> On Thu, 2 Aug 2007, John Fouhy wrote:
>
> > I'm not sure about PRAGMA, but you can do introspection in sqlite by
> > examining the table 'sqlite_master'.
>
> Thanks.  That's how I get the table names, actually.  But it doesn't give
> the column names.

It gives you the CREATE statement; you could just parse that :-)

-- 
John.


More information about the Tutor mailing list