SQLite Forum

Non primary key alias to rowid
This was my original design and it is not working with sessions in all cases. For example if there is a change set from an other database the global key has to be used. In this cases translationTextId. It would be nice if if you could write:

CREATE TABLE IF NOT EXISTS translatables(id AS (rowid), translationTextId TEXT PRIMARY KEY NOT NULL CHECK (translationTextId != ''), screenId TEXT, defaultText TEXT);