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