Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 224
  • 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

Thanks
0
madmare
Asked:
madmare
1 Solution
 
Vikas GargBusiness 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

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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