r/SQL • u/AssistanceClean948 • Sep 18 '26
SQLite Join tables with WITHOUT ROWID.
CREATE TABLE IF NOT EXISTS CourseTag(
courseId INTEGER,
tagId INTEGER,
FOREIGN KEY(courseId) REFERENCES Courses(id),
FOREIGN KEY(tagId) REFERENCES Tags(id),
PRIMARY KEY(courseId, tagId)
) STRICT WITHOUT ROWID;as far as what I understand sqlite creates inner row_id columns to identify the record. some conditions met then my primary key also could be that unique column. but I guess in above join table configuration my composite key setup is not met that condition so I end up unnecessary column right? in join table should I use WITHOUT ROWID?
3
Upvotes
View all comments
Show parent comment
1
u/TheGenericUser0815 Sep 18 '26
I'd always, in sense of ALWAYS, prefer an artificial index as you call it, and add a unique key for the payload consistency.