General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
MODI STRU and View Updates
Is there any way to make the process of adding fields to a table that is referenced by a ton of views less excruciating?
The only plan I have at present is to go through every view in the database (there are over 350 of them!) and write down which ones reference the table in question and the update information for each one that does. Then I will add the fields and go through each view on the list to reinstate the previous update status.
Yuck! Are there any better ways to do this?
(I use Visual Foxpro 6.0.)
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only