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?