Hey, I'm trying to the tables that my application is creating, and of course there are foreign key relations between tables. There are of course some limitations... Tables that have foreign key must be created after the foreign key column exists in its original table, and of course... you can't delete a table whose column is a foreign key somewhere else. So the creating and dropping problem. It seems like a classic case to implement a topological sort on the table structure (of course, assuming that there are no circular dependencies in the design...). Is there a way to create or drop all tables without the sort, except for of course actually implementing the topological sort manually, and choosing a valid creation sequence?
Submit an article or tip