Does v9 support both "ALTER" & "If exists .. DROP + CREATE"?

Barry K

I have run into this issue on numerous occasions. We have functions that call themselves recursively. If you add a parameter to the function that calls itself, simply doing an alter function will not work because it will give you an error that "the procedure or function has too many arguments specified".

If you drop and create the function, it will create it properly.

David Atkinson

The latest 9.5 Beta has options to add existence checks and DROP/CREATE.

More details here:
http://www.red-gate.com/MessageBoard/vi ... hp?t=14113

Please give it a go and let us know if this meets your requirements.

David Atkinson
Product Manager
Red Gate Software

David Atkinson

The latest 9.5 Beta has options to add existence checks and DROP/CREATE.

More details here:
http://www.red-gate.com/MessageBoard/vi ... hp?t=14113

Please give it a go and let us know if this meets your requirements.

David Atkinson
Product Manager
Red Gate Software