Use the Create Stored Procedure window to define a stored procedure to perform work that cannot be done with SQL DELETE, INSERT, SELECT, and UPDATE operations.
After the stored procedure is listed in your data model, you can select it and edit any of its properties in the Properties view. You can also set privileges on it.
When the stored procedure is ready, you can generate and run the DDL for creating the stored procedure in a metadata catalog.
If you need to modify the stored procedure after it exists in a metadata catalog, you must generate and run the DDL to drop the stored procedure from the metadata catalog. Then, you can re-create the stored procedure with the modified settings and generate and run the DDL.