How to change the procedure without deleting it?

[Former Member]

Hello,

I am new to SAP HANA. I am currently working on a procedure and I am facing a problem. I want to know that do I have to delete the procedure and table every single time If I want to make some changes to the procedure again after executing?

Is there any other way to change the procedure without deleting it again and again?

[lbreddemann · Accepted solution]

You definitely should spend some time with the documentation or the tutorials (e.g. youtube channel hanaacademy) to get at least a basic understanding of your development tools.

A "create or replace procedure" can be done on runtime procedures that have been created with the header option first.

But besides that, you should look into not just building runtime procedures, but to use the repository (WebIDE, Web-based workbench or HANA Studio).