SQLite Forum

views may have rowid?
>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?