About Pricing Community Teams Start Free Trial

VBdotnet2005

asked on 3/2/2015

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

Microsoft SQL Server 2008ASP.NETMicrosoft SQL Server

Last Comment

Vitor Montalvão

8/22/2022 - Mon

Simon

3/2/2015

select * from vw_customers_order where 1=2

Will get you just the headers without any data.

ASKER CERTIFIED SOLUTION

ste5an

3/2/2015

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

GET A PERSONALIZED SOLUTION

Ask your own question & get feedback from real experts

Find out why thousands trust the EE community with their toughest problems.

SOLUTION

JR2003

3/2/2015

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

⚡ FREE TRIAL OFFER

Try out a week of full access for free.

Find out why thousands trust the EE community with their toughest problems.

SOLUTION

PortletPaul

3/2/2015

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

⚡ FREE TRIAL OFFER

Try out a week of full access for free.

Find out why thousands trust the EE community with their toughest problems.

Vitor Montalvão

3/5/2015

VBdotnet2005, do you still need help with this question?

This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.

Certified Expert Program

Credly Partnership

Udemy Partnership