Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  Views don't automatically see table changes?

Author  Topic  bcurnow Starting Member 3 Posts Posted - 2001-02-14 : 17:16:12 I am having trouble with columns not appearing in a view when they are added to the view's underlying table(s). Here's a basic example: I have a table of customers (tblCustomers) and a view (viewCustomers). For various reasons the view is defined as: SELECT * FROM tblCustomers If I were to add a new column to tblCustomers, say cust_id, that column will not appear in the view until after I open and re-save the view. Is there any way around this? If not, is there an automatic way of refreshing the view?