Database Administrators Asked by Gandalf on January 2, 2022
I have been using mysql for the past number of years and i have always wondered? Lets say you have several tables and the tables are so interconnected, in an normal schema, you would have foreign keys all over.
What I do when i have to reference another table is to store the id of the table i am referencing and not indicate that its a foreign key.
Must you indicate in a table schema that a field is a foreign key so that you use JOIN keyword later on in my queries or can i still use joins if I understand which columns are foreign keys, they are just not indicated as such?
2 Asked on December 31, 2021
jobs sql server sql server 2012 sql server 2016 sql server agent
1 Asked on December 31, 2021 by daniel1791
1 Asked on December 31, 2021 by user2417731
1 Asked on December 31, 2021 by humberto-herrara
2 Asked on December 28, 2021 by khom-nazid
maintenance performance postgresql postgresql 9 6 postgresql performance
1 Asked on December 28, 2021 by guiik
database design performance postgresql postgresql 11 postgresql 9 6 postgresql performance
2 Asked on December 28, 2021 by edgar-ramrez-mondragn
0 Asked on December 28, 2021
1 Asked on December 28, 2021 by philhibbs
1 Asked on December 28, 2021 by strahinja-kustudic
execution plan postgresql prepared statement query performance
2 Asked on December 28, 2021 by mameo
1 Asked on December 28, 2021
0 Asked on December 28, 2021 by prdufresne
6 Asked on December 26, 2021
2 Asked on December 26, 2021 by user77410
1 Asked on December 26, 2021 by irfi
1 Asked on December 26, 2021 by arnau-ec
2 Asked on December 26, 2021 by linn-zacharias
disaster recovery high availability mongodb mongodb 3 2 mongodb 3 6
Get help from others!
Recent Questions
Recent Answers
© 2023 AnswerBun.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP