Have to know the actual column name from alias

[deepak]

Hi There,

i have a requiremet ,where in i have a view which has some alias.so at
runtime using an application i will get the info about the view using
SP_HELP stored proc,but this only gives me the alias names ,but i
need to know the original column name(as in the table defintion part
of the view) also.
could anybody throw light on this.
Hope i am clear

Cheers
Deepak

 

[=?ISO-8859-1?Q?G=F6ran_Andersson?=]

Hi There,

i have a requiremet ,where in i have a view which has some alias.so at
runtime using an application i will get the info about the view using
SP_HELP stored proc,but this only gives me the alias names ,but i
need to know the original column name(as in the table defintion part
of the view) also.
could anybody throw light on this.
Hope i am clear

Cheers
Deepak

That information is not easily available. The original data for a column
of the view doesn't have to be a simgle column from a single table. It
could be a complex expression or a literal value, for which there is of
course no original column name. You would have to parse the query for
the view to get the expression that is the source of the column.