Actually, we were talking about the schema format number at offset 44. However, neither that nor any of the other you point out will let you know if a without rowid table is present. That's discovered when parsing the contents of the sqlite_master table. Peter
From: Simon Slavin <slav...@bigfraud.org> >To: Peter Aronson <pbaron...@att.net>; General Discussion of SQLite Database ><sqlite-users@sqlite.org> >Sent: Friday, November 15, 2013 3:29 PM >Subject: Re: [sqlite] Intended use case for 'without rowid'? > > >I'm confused. By 'Schema Version Number' are people meaning this: > ><http://www.sqlite.org/pragma.html#pragma_schema_version> > >Or the header string at offset 0 in this: > ><http://www.sqlite.org/fileformat.html> > >Or the value written at offset 92 in this: > ><http://www.sqlite.org/fileformat.html> > >? > >The first one, which has a name nearest to 'Schema Version Number', should >have nothing to do with databases popping up with 'without row'. On the other >hand, an application which is testing to see whether it understands the file >format can usefully check the value at 92 and make sure it's less than or >equal to such-and-such value. Beginning to allow 'without rowid' must >increase the value used. > >Simon. > > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users