qlite] getting table column names and types
> programaticly
>
> Jim Dodgen wrote:
> > Anyone know how I can query the field names and types for a
> given table?
>
> Jim,
>
> select sql from sqlite_master where type="table" and name="gigo"
> Anyone know how I can query the field names and types for a given table?
pragma table_info(tablename)
Jim Dodgen wrote:
Anyone know how I can query the field names and types for a given table?
Jim,
select sql from sqlite_master where type="table" and name="gigo"
will get something like:
create table gigo(a,b,c)
which includes the field names, and would include the types if I had
used any.
Gerry
Anyone know how I can query the field names and types for a given table?
4 matches
Mail list logo
