How do we list all column names of a table?

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

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

Bookmark It

< Previous : What are the steps to create a stored procedure?

Next > : How do we List all table names?

More Interview Questions by Nishithraj

Latest Interview Questions