SQLite Forum

about "strict" mode
Login
> No, implicitly generated rowids are NOT stable.

You are incorrect.  Implicitly generated rowids **are** stable.


```
create table x
(
  rowid integer primary key,
  y
);
insert into x (y) values (1);
```

The rowid is implicitly generated but is stable.

You are confusing the rowid itself (which may be specified either explicitly or computed implicitly) with whether or not the rowid is being stored in an explicitly designated column and is part of the row data.

```
create table x
(
 y
);
insert into x (rowid, y) values (1,1);
```

Although the rowid is explicitly generated, it is stored in an implicitly defined column are therefor does not constitute part of the row data.