Alter U-SQL Procedure

allysky 21 Reputation points
2020-08-20T02:24:33.54+00:00

I have an existing stored procedure in U-SQL database and need to update additional log to it. But i cannot seem to update it, How can i update the procedure

Azure Data Lake Analytics
{count} votes

Accepted answer
  1. Vaibhav Chaudhari 38,606 Reputation points
    2020-08-20T07:52:38.127+00:00

    I don't see ALTER PROCEDURE syntax available for U-SQL in the documents. However we can simply DROP existing and CREATE new SP. Take backup before you DROP it.

    Reference - U-SQL - procedures

    19057-image.png

    ----------

    Please don't forget to Accept Answer and Up-vote if the response helped -- Vaibhav

    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. allysky 21 Reputation points
    2020-08-20T21:14:06.867+00:00

    that's what i got. just wanted to confirm.

    0 comments No comments