List the COLUMN_NAME in MS SQL Tables

SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.Columns where TABLE_NAME = 'mpidallergy'

For all Tables

====================================================

SELECT table_name=sysobjects.name,

column_name=syscolumns.name,

datatype=systypes.name,

length=syscolumns.length

FROM sysobjects

JOIN syscolumns ON sysobjects.id = syscolumns.id

JOIN systypes ON syscolumns.xtype=systypes.xtype

WHERE sysobjects.xtype='U'

ORDER BY sysobjects.name,syscolumns.colid