SDU Tools: CalculateTableLoadingOrder - follow table dependencies in T-SQL
If there is a reasonable number of tables in a SQL Server database, and I’ve also got foreign keys linking them, it can be difficult to work out the order of the dependencies. That’s a hassle when I want to load data, and for other admin functions that I might need to perform. So we’ve fixed that.
In our free SDU Tools for developers and DBAs, there’s a stored procedure called CalculateTableLoadingOrder.
2019-04-10