Replies: 1 comment
-
|
Use this one: |
Beta Was this translation helpful? Give feedback.
0 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
Details
I have two tables that are linked by two columns. I'd like to add a foreign key here to see it my query runs faster. SQLiteStudio can only create a foreign key for a single column to the other table, not for two columns. I'm pretty sure SQLite supports that, but I'll have to look up the SQL syntax for it. It would be nice if the UI would allow me to do that more quickly.
Update: Looks like I cannot add a foreign key to an existing table with SQLite (it's so limited it can barely do anything…), so the extra work SQLiteStudio does by creating the temporary table would be extremely useful here!
Beta Was this translation helpful? Give feedback.
All reactions