How do we list all column names of a table?

 Posted by Nishithraj on 1/5/2010 | Category: Sql Server Interview questions | Views: 2491
Answer:

Using the query

SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.Columns where TABLE_NAME = 'Emp' ORDER BY COLUMN_NAME


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response