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 |
|
stanleytk
Starting Member
4 Posts |
 Posted - 2001-05-03 : 10:57:19
|
| I am developing on SQL 7.I have created a view which combines 2 tables. I want to see all the columns of Table 1 and 2 columns of Table 2.At times (very infrequently), a new column may be needed to be added to Table 1. I have created a stored procedure which will handle this event. As well, when this happens, the View of Table 1 no longer includes all the columns. I would like to include in this stored procedure the function to "refresh" this view. How do I accomplish this?I have tried the "Alter View" SQL statement, but this doesn't work, I think it is only available with SQL 2000. Any ideas would be greatly apprecisted.thank you,Ken |
|
|
|
|
|
Refreshing a View