Please note : This help page is for an older version of Enteprise Archtiect. The latest help can be found here.

Stored Procedures

Stored Procedures are subroutines that group SQL statements or operations to perform a specific task, processing table data on the DBMS server. They can be called from an external application.

Stored Procedures are often used where there is a need to reduce network usage between clients and the DBMS servers. Enterprise Architect models Stored Procedures using stereotyped UML Classes and Operations. These can be generated with a schema for loading onto the DBMS server.

Procedure-element

Toolbox icon

e_procedure

Learn more

Learning Center topics

(Alt+F1) | Enterprise Architect | Database Engineering | Physical Data Model | Stored Procedures