SQLite Forum

Does table have rowid?
Login
I tried it and got this:

````
sqlite> select sqlite_version();
sqlite_version()
3.31.1
sqlite>    SELECT name,
   ...>           NOT EXISTS(SELECT 1 FROM pragma_index_info(x.name)) AS 'hasRowid'
   ...>      FROM sqlite_schema AS x
   ...>     WHERE type='table'
   ...>     ORDER BY name;
Error: no such table: sqlite_schema
````
Is it version dependent?