DiverseAndRemote.com
Reputation: 19888
Is there a set identity_insert on equivalent for SQLite?
In TSQL there is
SET IDENTITY_INSERT ON;
is there a functional equivalent in SQLite?
Upvotes: 15
Views: 6250
Answers (1)
CL.
Reputation: 180020
SQLite always allows inserting a value into the primary key column; automatically generated values are used only when the inserted value is NULL (explicitly or omitted).
For details, see the documentation.
Upvotes: 20
Related Questions
- Is there AUTO INCREMENT in SQLite?
- Sqlite insert into with unique names, getting id
- Insert Identity using Microsoft.EntityFramework.Sqlite.Core
- SQLite AUTOINCREMENT non-primary key column
- SQLite multiple Autoincrement Columns?
- SQLite insert primary key only
- Is there a way to automatically generate identity row values in SQLite
- Get ID of autoincrement field in SQLite
- sqlite: how can I add an autoincrementing id to an existing table?
- Does SQLite have something like insert_id?