Monday, January 27, 2014

Get columns name of a table in SQL SERVER

Dear All

this is for new user those face problem

Get columns of a table SQL SERVER

 In SQL IDE:-

select column_name from information_schema.columns
 where table_name = 'You_TableName'
order by ordinal_position

Note :- same query also work in code-behind.