• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 226
  • Last Modified:

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

1 Solution
Vikas GargBusiness Intelligence DeveloperCommented:

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

as shown in the below image

Alter View
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.
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.
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.

Join & Write a Comment

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now