Get the Foreign Key Hierarchy 2

This procedure is just another approach for getting a list of tables defined in a database, ordered by dependency on other tables based on foreign key relationship.I used it for a deployment process, where the TABLE create scripts must be executed in the correct order,because the foreign key constraints are specified in the create script […]

4.5 (2)

2003-04-18

311 reads

Blogs

Keynotes in Australia and New Zealand

By

I get to do the SQL in the City Summit keynotes in Australia and...

Event Log File Paths

By

How does one consistently find the correct path to the Extended Event Log file...

Clearing an Email from the Microsoft Directory

By

Years ago I was working on a demo with Microsoft and someone added me...

Read the latest Blogs

Forums

The Change Failure Rate

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Change Failure Rate

DBA Walkthrough – Adding space on IBM AIX Power Machines

By SOLVARIA

Comments posted to this topic are about the item DBA Walkthrough – Adding space...

The Datatimeoffset Value

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Datatimeoffset Value

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers