how to fetch column name of the table?

Question

Hello all Is there any way through query to get the table schema information?? I am using MS SQL Server Express which is inbuild with .Net 2005. I want to fetch all the coumn name to display on the Form. Plz suggest the Query...

try abc · Answer

Thnaks Jan Montano Its really very helpfull.

Jan Montano · Answer

select * from information_schema.columns (where tablename = @tablename)