When View is made in sqlite, it's unvisibible on the view's list. Always there is View(0), while I can use this view. The problem is you must remember the name. While I use DBeaver, it's visible.
VIEWs not visible on the views list
Yes, SQLite views are currently unsupported in HeidiSQL. There is a feature request for supporting these: see issue #1196
Please login to leave a reply, or register at first.