Dear Experts,
Please advise on how one can generate scripts to change the definition of some of the columns in a tables along with the drop and recreate of dependent objects like indices and constraints related to those columns . If you can suggest any tool , would be great. I did this for many objects and then manually created scripts for re-use ,but want to check if this can be done with a smarter way. I'm not familiar with any scripting tool.
Thanks....Arshad