How to retrieve real column name of multiple time used alias column in a view in SQL Server 2008?

Asked Feb 21 '15 at 10:55

Active Feb 21 '15 at 14:19

Viewed 119 times

How to retrieve real column name of multiple time used alias column in a view?

My table is

 ----------------
|colname |TYPE |
 ----------------
|Column1 |int  |
|Column2 |nchar|
|Column3 |nchar|
 ----------------

And this is my view:

CREATE VIEW myView 
AS
   SELECT  
       Column1 as UserID,
       Column1 as customerID,
       Column2 as name ,
       Column3 as gender ,
    FROM 
       myTable  
GO

How to get my view original name and datatype and column name using view ?

Expected output like

 ---------------------------
|REALNAME|TYPE |ColName   |
 ---------------------------
|Column1 |nchar|UserID    |
|Column1 |nchar|customerID|
|Column2 |nchar|name      |
|Column3 |nchar|gender    |
 ---------------------------

Thanks in advance.

edited Feb 21 '15 at 14:19

Reza

18,865
13
88
163

asked Feb 21 '15 at 10:55

sss

Which dbms are you using? – jarlh Feb 21 '15 at 10:58
3

possible duplicate of http://stackoverflow.com/questions/10048056/find-the-real-column-name-of-an-alias-used-in-a-view – Ameya Deshpande Feb 21 '15 at 11:00
already i tried that.but colname name is display sequence – sss Feb 21 '15 at 11:04

How to retrieve real column name of multiple time used alias column in a view in SQL Server 2008?

0 Answers0