Toad World® Forums

ALTER procedure produced drop/create syntax


#1

I noticed that ALTERing a function or procedure still causes the script to drop then create the object. It would be preferable to create a real ALTER script.

The first image is from SQL Server. An ALTER there creates the proper script. The second image is from the Sybase beta. Note the DROP then the CREATE statements.

sqlserver_alter.png

sybase_alter.png


#2

Hello Larry,

Just update this post altering a procedure in IQ and SA will now create a alter script.

Thanks.