Stored procedures
To update the code of stored procedures:
-
Run
ALTER GIT REPOSITORY <name> FETCHto propagate changes (doc) -
If using
create_all.sqlto 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.