On Sun, 12 Feb 2017 12:40:27 -0700
"Keith Medcalf" wrote:
> I am aware that it works if you quote the apparently reserved word
> "notnull".
That's the queer part. I can imagine "not" and "null" as keywords, but
not "nonnull".
--jkl
On Sunday, 12 February, 2017 11:03, Domingo Alvarez Duarte
wrote:
> Hello Keith !
> You can try this that works:
> select m.name as TableName,
> i.cidas ColumnID,
> i.name as ColumnName,
> i.type as Affinity,
>
Hello Keith !
You can try this that works:
select m.name as TableName,
i.cidas ColumnID,
i.name as ColumnName,
i.type as Affinity,
i."notnull"as CanBeNull,
i.dflt_value as DefaultValue,
i.pk as PrimaryKeySeq
from
select m.name as TableName,
i.cidas ColumnID,
i.name as ColumnName,
i.type as Affinity,
i.notnullas CanBeNull,
i.dflt_value as DefaultValue,
i.pk as PrimaryKeySeq
from sqlite_master as m,
4 matches
Mail list logo