Technical Article

Stored Procedure Call Hierarchy

Easily extractss the complete stored procedure call hierarchy from "sysdepends" table of SQL Server and represent it in a pseudo-graphical tree-view.The script uses a temporary table (automatically created/dropped) to hold children and parents of relationships. For representing the call hierarchy the table contains a level field (depth) and a field containing the "enumerated path" (using […]

5 (5)

You rated this post out of 5. Change rating

2005-03-14 (first published: )

3,605 reads

Technical Article

Database structure queries

Gets most important information of database structure. This includes all user tables, their fields, datatypes, defaults (including default constraint names), etc, primary keys and their fields, unique constraints and their fields, check constraints (including their conditions), foreign key constraints and their fields aswell as any other indexes and their fields. Should be quite useful for […]

5 (2)

You rated this post out of 5. Change rating

2002-04-08

3,033 reads

Blogs

Speaking at SQL Saturday Boston 2023

By

I’m heading to Boston next week for SQL Saturday Boston 2023. I went to...

SQL Prompt Quick Access to Helper Code

By

We’ve been doing some events as part of the Redgate Roadshow, and at one...

Eleven chapters of my data architecture book are available

By

As I have mentioned in prior blog posts, I have been writing a data...

Read the latest Blogs

Forums

Elevating Efficiency: Cloud-Based ERP Software in the UAE

By muhammadtoha12255

Hello, esteemed forum members, I'm currently in the process of exploring cloud based erp...

Best Sildenafil Is The Fildena 100mg For Male Protection

By Eliadavised

Fildena 100 mg is used to deal with sexual issues. This medication is taken...

Building Bonds with Entertainment

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Building Bonds with Entertainment

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers