On Fri, 15 Nov 2013 16:16:34 -0500
Richard Hipp <d...@sqlite.org> wrote:

> On Fri, Nov 15, 2013 at 4:11 PM, RSmith <rsm...@rsweb.co.za> wrote:
> 
> > I would still like to see some kind of function, even a totally new
> > one that does not affect any backward compatibility, such as:
> >
> > *BOOL sqlite3_table_has_rowid(*tbl);
> 
> How about this:
> 
>    SELECT 1 FROM sqlite_master WHERE sql LIKE '%without%rowid%';

Actually, this discussion highlights the fact that row_id always was an
attribute of a table, however hidden and magical.  Better than a new
function would be a new column in SQLITE_MASTER.  (LIKE is
often a clue that an attribute is encoded in the text!)  

--jkl
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to