Link to home
Start Free TrialLog in
Avatar of VBdotnet2005
VBdotnet2005Flag for United States of America

asked on

select header from view in sql

Is there a way to get column headers from a view?

select top (1) * from vw_customers_order

id      1
name    John
address  123 Beach st.
etc
Avatar of Simon
Simon
Flag of United Kingdom of Great Britain and Northern Ireland image

select * from vw_customers_order where 1=2

Will get you just the headers without any data.
ASKER CERTIFIED SOLUTION
Avatar of ste5an
ste5an
Flag of Germany image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
VBdotnet2005, do you still need help with this question?