How to retrieve all the column names from table?

Posted by vishalneeraj-24503 on 12/17/2013 | Category: Sql Server Interview questions | Views: 1880 | Points: 40

Answer:

It's very simple and easy way to get all the column names the Table has.

Write below query:-

Select Top 0 * From Employee_Master;

Top 0 * will no fetch any rows only columns will display.

Asked In: Many Interviews | Alert Moderator

Bookmark It

< Previous : How to retrieve only the structure of a DataTable ...

Next > : How to change Button color as transparent dynamica ...

Posted by: Palnati on: 12/18/2013 | Points: 10

Hi It's good,

But i want to display these columns in row format i.e one by one.

Is is possible ?

Thanks
Rajkumar Palnati
9949128921

More Interview Questions by vishalneeraj-24503

Latest Interview Questions