Show/Hide Toolbars

TMS Data Modeler Documentation

Navigation: Editors

Procedures and Functions

Scroll Prev Top Next More

To open the procedure editor, you should double-click on the desired procedure/function on the Project explorer.


Procedures (or "stored procedures"), like triggers, are functions programmed into the database. Through TMS Data modeler, you can edit and create procedures as shortcuts to regularly executed actions, and store them for future use. In this editor, you are able to set:


Object name: procedure name




Create implementation code: full command to create the stored procedure in the database. When you create a procedure, it automatically implements "CREATE PROCEDURE <%ObjectName%>". This macro "<%...%>"  is replaced by the procedure's name, so you can rename it without having to update this implementation.