Solved

Diagram Stored Procedures & tables

Posted on 2004-10-29
467 Views
Last Modified: 2008-03-17
Hi,

I just learned how to diagram tables.  But is there a way to diagram stored procedures as well?  In particular I'd love to see tables and stored procedures arranged logically with arrows indicating their relationships.

An answer of no would be as helpful as yes.  

If, in addition, someone can recommend some freeware that can help me with this, that would be great.

Thanks in advance!
Evan
0
Question by:EvanBrenner
    3 Comments
     
    LVL 6

    Expert Comment

    by:mcp111
    stored procedure could involve multiple tables. how can you have a relationship between a stored procedure and a table?
    0
     

    Author Comment

    by:EvanBrenner
    A stored procedure could call, manipulate, and delete multiple records from multiple tables.  (As I understand it.)
    0
     
    LVL 6

    Accepted Solution

    by:
    Database diagrams can relate tables. As far as I know there is no tool to relate tables and stored procedures.
    0

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
    Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
    Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
    Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

    931 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now