Search code examples
sqlclassstored-proceduresumldiagram

using visio 2007, how do I represent a trigger and a stored procedure?

I have a web service class diagram, I want it to show what stored procedures a web method calls.

for now, I just use a class with a metod inside to represent a stored procedure, something like

storeStuff(in this, in that, out field1, out field2)

but this consumes tons of space, any tips?

or are there any better ways to do this?

thanks

Solution

  • so I found this http://www.agiledata.org/essays/umlDataModelingProfile.html#Figure3Keys and this http://www.agiledata.org/essays/umlDataModelingProfile.html#Figure5

    wich visio does well, but you can't specify what the resultset is.

    anyone got anything better?