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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-08-09 : 09:21:21
|
| Adrian writes "If I have a view which is SELECT * FROM TABLE1 and then add extra fields to TABLE1 why does the view not show the new fields? I find it strange that I have to go into design mode for the view & save it without making any changes for the additional fields to be output.I have experienced this behaviour on 3 different servers all on SQLServer 7 (SP3) & NT4 (SP6).ThanksAdrian" |
|
|
|
|
|
VIEW NOT REFRESHED WHEN NEW FIELDS ADDED