Sample Header Ad - 728x90

Table Creation Order

2 votes
3 answers
3186 views
I have designed my database model with entities and they have relations along with normalization. Now I want to implement my design in my database engine. Before implementing I am puzzled with the order of table creation. Which pattern should I follow? 1. the tables with no foreign keys first 2. the tables with foreign keys Or would it be better to follow this order: 1. tables without any foreign keys 2. tables which are connected with that table I am new to database design. So forgive me if i am asking this awkward question. I am implementing my design via mysqlworkbench 8.x
Asked by Shaker Kamal (23 rep)
Jan 27, 2020, 10:59 AM
Last activity: Jan 30, 2020, 04:39 PM