Stored procedures

To update the code of stored procedures:

  1. Run ALTER GIT REPOSITORY <name> FETCH to propagate changes (doc)

  2. If using create_all.sql to mass-create the stored procedures, re-run:

    EXECUTE IMMEDIATE FROM @sentry_repo/branches/main/deployment_models/git-repository/create_all.sql;
    

    Otherwise, if running individual queries using EXECUTE IMMEDIATE, nothing needs to be done since it will automatically use the latest version from the repository.