>Brain fart fixed Obviously not at your end Look at the steps leading up to my question ... more carefully. 1. I am not looking for a column arbitrarily named 'rowid' in a view. 2. I am using DRH's code to establish whether a given object has the implicit primary column named 'rowid'. 3. Found that for a view, that code returns 1. Hence the [original](https://sqlite.org/forum/forumpost/7e131f970e?t=h) question. To make it simpler, my question is this: Is DRH's code >SELECT count(*)==0 FROM pragma_index_info($tablename); inapplicable/unreliable when dealing with views?