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 |
|
thaniparthi.rao
Yak Posting Veteran
96 Posts |
 Posted - 2008-10-03 : 23:39:53
|
| Hi to all,If we create a view which is extracting the data from a single table.Create view XYZ as select * from Table1.If we add some columnns or delete some columns from the table1 , is the changes reflect in the view or we need to do anything manually.Thanks,Thaniparthi |
|
|
ranganath
Posting Yak Master
209 Posts |
Posted - 2008-10-04 : 00:19:38
|
| Hi,it will not Reflect in the view.Bcoz u r not specifying column names. |
 |
|
|
thaniparthi.rao
Yak Posting Veteran
96 Posts |
Posted - 2008-10-04 : 00:25:22
|
| Is there any way to dynamically reflect the changes from table to view.Thanks,Thaniparthi |
|
|
|
PeterNeo
Constraint Violating Yak Guru
357 Posts |
Posted - 2008-10-04 : 01:02:29
|
| U need to alter the view or drop and create it again.When u create a view use WITH SCHEMABINDING option, then it ll warn u of any changes made to a table. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-04 : 02:32:58
|
| or use the system stored proceduresp_refreshview <viewname>to refresh the metadata of the view to pick new columns. |
|
|
|
|
|
|
view