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 |
|
goligol
Posting Yak Master
128 Posts |
 Posted - 2011-06-29 : 11:27:37
|
| Hi,I would like to rename the name of a VIEW, but since I have crated the other views which is calling this view, I would like to make sure by renaming the name of the VIEW, its name will be changed in the entire database, (in the other views which are calling the view with the new name)Thank you |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2011-06-29 : 11:40:46
|
| It means finding where it is referenced and changing those objects.As an interim you could create a new view with the old name which just selects from the new named view.You can search syscomments for references to the view or use tables refeernced in information_schema.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
goligol
Posting Yak Master
128 Posts |
Posted - 2011-06-29 : 12:55:55
|
| Thank you |
|
|
|
jimf
Master Smack Fu Yak Hacker
2875 Posts |
Posted - 2011-06-29 : 13:23:08
|
| Could you use a synonym here?JimEveryday I learn something that somebody else already knew |
|
|
|
|
|
|
Renaming a View name