how to add foreign keys in SCRIPTCASE to database

Scriptcase 9 General
#1

is it possible in a SCRIPTCASE project, to add foreign keys to a table? If YES someone can explain to me how to do it. I tried through the SQL commands but with no results. Where am I wrong?

#2

You need the database designer which is adminer. See https://www.youtube.com/watch?v=A42FG4LzdbY

#3

I think the embedded SC Database Builder can add foreign keys.
I don’t use it, but it seems a capable tool.
No idea if it’s reliable…

#4

Hi, what is the database engine used?, and please share a screenshot of the sql statement.