I have to create tables where both have each as the foreign key . Which one should be created first
It doesn't matter--create both of them without the foreign key constraint, and then alter the tables to add the constraints.