Removing an Exported Stored Procedure from SAP HANA

You can delete an exported stored procedure from SAP HANA using SAP HANA Studio. Ensure that your account is defined in SAP HANA.

To remove the exported stored procedure from SAP HANA, perform the following steps:

  1. In SAP HANA Studio, navigate to the procedure that you exported.
    Note You can find the exported procedure under the Procedure folder of the schema.
  2. Right-click the procedure and choose Open Definition.
    The Definition tab appears.
  3. Under Definition tab, choose Create Statement tab.
  4. On the Create Statement tab, copy the SQL comments (that is, commands preceded with double hyphen '--').
  5. On the Navigator tab, right-click the procedure and select SQL Console.
    The SQL Console tab appears.
  6. On the SQL Console tab, paste the SQL comments and choose Execute, or press F8.
    Note Ensure that before executing the comments, you delete the double hyphen (--) that precedes the SQL comments.