Yes, but to use the rowid or a table in a foreign key declaration you need to specify it explicitly in the table definition declaring it as the INTEGER PRIMARY KEY. (and exactly INTEGER PRIMARY KEY, although you can also add the AUTOINCREMENT keyword if you need to ensure unique values for some reason).
eg: CREATE TABLE test (rowid INTEGER PRIMARY KEY, data text); You need to do this because if you do not then the rowid is merely an internal identifier for the row in the underlying table b-tree structure and is not "stable" across vacuum or dump/load operations. --- The fact that there's a Highway to Hell but only a Stairway to Heaven says a lot about anticipated traffic volume. >-----Original Message----- >From: sqlite-users [mailto:sqlite-users- >boun...@mailinglists.sqlite.org] On Behalf Of Roman Fleysher >Sent: Monday, 24 July, 2017 12:58 >To: General Discussion of SQLite Database >Subject: [sqlite] rowid as foreign key > >Dear SQLiters, > >Is it possible to link two tables using rowid, the implicit column? I >tried and it did not work, so I presume the answer to my question is >"no". > >Thank you, > >Roman >_______________________________________________ >sqlite-users mailing list >sqlite-users@mailinglists.sqlite.org >http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
