Altering the View in SQL Server 2005

Hello Friends,

I have a view in SQL Server DB. I need to change the alias name of the column

SELECT AU.[Login],  
 ISNULL(AU.[LastName], ' ') AS 'LastName',  as LastName2

How do i do it?
SubbuUSAAsked:
Who is Participating?
 
SharathData EngineerCommented:
Alter the View definition.
ALTER VIEW ViewName AS 
SELECT AU.[Login], 
       ISNULL(AU.[LastName], ' ') AS LastName2  

Open in new window

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.