Subject | How to drop an procedure only if exists... |
---|---|
Author | adrian_avila_mtz |
Post date | 2006-01-17T16:58:23Z |
I have an update script to be aplied automatic that need to drop a
procedure, some of the DB have the procedure named 'UTIL01' if the
procedure exists there is no problem, but if it doesn't exists it gets
an error and since the update must be clean and automatic I need to
used the drop procedure sentence only if the procedure exists to don't
get the error in the update.
Any ideas?
Thx.
procedure, some of the DB have the procedure named 'UTIL01' if the
procedure exists there is no problem, but if it doesn't exists it gets
an error and since the update must be clean and automatic I need to
used the drop procedure sentence only if the procedure exists to don't
get the error in the update.
Any ideas?
Thx.