Toad World® Forums

Feature about Alter SQL Script


#1

Feature about Alter SQL Script to alter SQL table, view / stored procedure.

Hi

I am wondering if it is possible to generate Alter SQL script in which after we alter some of the model in Toads (E.g. Add or remove some of the attribute and change the size of the field) When we want to update the model from Toad to the actually database, we could just run the script on the database server to made the changes.

Especially the feature that allow us to generate Alter SQL script when compare the model, so we will be able to update the database structure but using the alter SQL script.

Because if we the create script, which may drop the table and re-create it again. If we can just the compare function and generate the SQL script, which could just alter the table when necessary and the data which is on the current table will not be erase(drop)

Please let me know if you want me to explain more.

Many thanks

Chi


#2

Hello Chi,

Yes, alter scripts will be supported. We’ve been working on this very hard to finish it for current BETA 3.0.3103, however haven’t managed to finish it in time finally.

We’re still working on this. Thanks for your patience.

Regards,

Vladka & TDM Team