Hello Keith !
You can try this that works:
select m.name as TableName,
i.cid as ColumnID,
i.name as ColumnName,
i.type as Affinity,
i."notnull" as CanBeNull,
i.dflt_value as DefaultValue,
i.pk as PrimaryKeySeq
from sqlite_master as m,
pragma_table_info(m.name) as i
where m.type='table';
On 12/02/17 15:24, Keith Medcalf wrote:
select m.name as TableName,
i.cid as ColumnID,
i.name as ColumnName,
i.type as Affinity,
i.notnull as CanBeNull,
i.dflt_value as DefaultValue,
i.pk as PrimaryKeySeq
from sqlite_master as m,
pragma_table_info(m.name) as i
where m.type='table';
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
