I have been developing a database, and have typically made all changes in my logical model, then convert it to a physical model, and produce the relevant DDL script.
In my physical model, I have around 100 entities (tables), many with a field called 'updated'. I want to add an index on that field, in each table. How do I do this in bulk?
There is no functionality like this. It can be achieved only by writing a custom script for it.