How to retrieve all the column names from table?

 Posted by vishalneeraj-24503 on 12/17/2013 | Category: Sql Server Interview questions | Views: 1921 | 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 

Comments or Responses

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

Login to post response