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