Posted by Silas on 10/01/03 11:25

Hi,

I use view to join difference table together for some function. However,
when the "real" table fields changed (e.g. add/delete/change field). The
view table still use the "old fields".

Therefore everytimes when I change the real table, I also needed open the
view table and save it by SQL enterprise manager manually for update the
view table field.

Can we use a SQL command or other method to update it directly?

Regards,
Silas

• Next in forum: Re: All records within x minutes of each other
• Prev in forum: Re: restore problem about sql server
• Thread view: View field content update when "real" table fields change

[Reply to this message]