WITHOUT ROWID tables

Wayne Collins <[email protected]>
Newsgroups gmane.comp.db.sqlite.general
Message-ID <[email protected]>
My first posting so I hope I get the etiquette correct.

1st question How can I determine from a C-program if a table was 
generated with the "WITHOUT ROWID" option? I have an application where 
it is important to know if a table has a rowid or not.

2nd Question After a database is defined and the tables created, I have 
an application which automatically generates C++ DAO and DTO objects for 
each table. At run time, I'd like to be certain that the schema and the 
DAO/DTO match. I had thought to use the schema_version pragma but it 
increments when the db is VACUUMED. Is there some hidden cookie or value 
I can use that I have overlooked?

Thanks in advance


_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.