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

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?
0
SubbuUSA
Asked:
SubbuUSA
1 Solution
 
SharathData EngineerCommented:
Alter the View definition.
ALTER VIEW ViewName AS 
SELECT AU.[Login], 
       ISNULL(AU.[LastName], ' ') AS LastName2  

Open in new window

0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

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