Re: [sqlite] pragma_table_info column name is interpreted as reserved work?

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

Re: [sqlite] pragma_table_info column name is interpreted as reserved work?

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, >

Re: [sqlite] pragma_table_info column name is interpreted as reserved work?

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

[sqlite] pragma_table_info column name is interpreted as reserved work?

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,