Recently a need resurfaced to explore the foreign key tree (hierarchy/genealogy) as it related to a specific table within a database. As I pulled out the script from the repository, I realized there was some […]
Tag: FK Hierarchy
Table Hierarchy goes CS
At the urging of a friend, this script is being updated for those that are dealing with Case Sensitivity. The first few rounds, I neglected Case Sensitivity and never tested for that. It makes sense […]
FK Hierarchy v 2.1
Last month I published an update to my Foreign Key Hierarchy script. Today, I am providing a new update for that script. A friend (Rémi Grégoire) helped out with some mods to this script. The […]
Foreign Key Hierarchy Update
Today I would like to revisit a post of mine that is rather old. More precisely, the script in that post needs revisiting. This is one of my more favorite scripts and I still have […]
T-SQL Tuesday #18 – CTEs
To CTE or not to CTE, that is the Question So my post really has nothing to do with the title. This is not a post to help you determine whether a CTE is appropriate […]
Key Discovery III
Recursively traverse system views to build a Hierarchical Perspective into the database.