SQLite Forum

views may have rowid?
Login
This follows from [this hint](https://sqlite.org/forum/forumpost/0ab9771c80?t=h).

My session:

```
SQLite version 3.34.0 2020-12-01 16:14:00
Enter ".help" for usage hints.
sqlite> .open 'D:\SQLite32\DB\rosellamodel Sample Bug Report SQLITE.db'
sqlite> select tbl_name,type from sqlite_master where tbl_name = '__magicMaterialiser__';
tbl_name               type
---------------------  ----
__magicMaterialiser__  view
sqlite> SELECT count(*)==0 FROM pragma_index_info('__magicMaterialiser__');
count(*)==0
-----------
1
```

1. The database is from a user in this forum; I can't find the link but its the one DRH was 'going to keep'.
2. The type is 'view'
3. It has rowid according to DRH's tip.

How come views have rowid?