How to Modify Names in an SQL View?

[WWGD]

Does anyone know how to change names in an SQL view (i.e., a sort of a subset of a database. We may create it by saving a query and then doing a query on this saved query )?
Thanks.

 

[jedishrfu]

Do you want to change the name of the SQL view? or change the column names?

What database are you using?

http://en.wikipedia.org/wiki/View_(SQL)

I think you just delete the view and then recreate with your changes.

Here's one example using the ALTER command:

http://dba.fyicenter.com/faq/sql_server/ALTER_VIEW_Modifying_Existing_Views.html

 

[WWGD]

Hi, thanks. It is kind of hard for me to export the database here. I am interested in changing the name of a field within a view in SQL.
Thanks for the links.

 

[avarmaavarma]

You need to use 'ALTER VIEW' e.g.

ALTER VIEW HumanResources.EmployeeHireDate
AS
SELECT p.FirstName, p.LastName, e.HireDate
FROM HumanResources.Employee AS e JOIN Person.Person AS p
ON e.BusinessEntityID = p.BusinessEntityID
WHERE HireDate < CONVERT(DATETIME,'20020101',101) ;
GO

 

[WWGD]

Thanks, avarma^2