Have to know the actual column name from alias

  • Thread starter Thread starter deepak
  • Start date Start date
D

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
 
deepak said:
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
Click to expand...

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.
 
Back
Top