I use MySQL Workbench to model my database. In it, I have the ability to create relationships by defining foreign keys, etc. What is the meaning of this? I can’t work with my requests without any problems.
My tables have an actual column for foreign keys, I just did not define them in MySQL Workbench. So I have no lines connecting the tables.
Foreign keys do a few things. Most obviously, they provide you with built-in data integrity, as Macy Abbey mentioned.
, , , . , , , . . ?. SQL Server, , .
. , , .
, . ; , , ( - ).
, :
. , , , . , .
, , , . , .
, . , , . , . , , , sql .