sql server 2008 modify view

Hello Experts,

 I have an view in SQL Server 2008, How do I Modify this View ?

I have opened it in Design Mode then added a new clolumn then save.

unfortunatly it disen't work

Thanks
madmareAsked:
Who is Participating?
 
Vikas GargConnect With a Mentor Business Intelligence DeveloperCommented:
Hi,

You can right click on view => Scipt view as => Alter To

as shown in the below image

Alter View
0
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
Another possibility is that you have select privs on the view, but not alter, therefore any changes to the view does not save.
0
 
Anthony PerkinsCommented:
unfortunatly it disen't work
Can you elaborate and explain to us what this means?  Is it:
A. An error message, if so what is it.
B. The wrong results, if so what are they and what are the expected results.
C. Something else.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.