How can i diagram stored procedure?

[rezaTech]

hi there
i work for a large banking system. I have some very large stored procedures written in SQL Server 2005. I want to show the logic of those sp's in diagram for better understandibility. Which UML diagram would be appropriate for this? I am thinking about sequence diagram but not quite confident. can anybody  help me?

[RoyC]

Use a Data Model diagram. Read about these and Stored procedures in the EA Help, Data Modeling section.  You can find the topics on stored procedures very quickly using the index.

[Frank Horn]

You could model the stored procedures as operations of a class representing the database, and then draw sequence diagrams with a client lifeline and a database lifeline to show which stored procedures are called from the client and (as self messages on the database lifeline) how they interact.

If more details are to be shown (like what the procedures are doing internally) I would model them as (complex) activities, and maybe the tables and views as objects within the activity diagrams (to show which tables or views are used by the procedures).

Or you could start off with a class diagram (each table, view and procedure a class) using dependencies, and then add sequence and/or activity diagrams to the procedure classes as needed.