how to output column names

Hi,

Is there a query I can perform (perhaps on a system table) to return all of the column names  (ONLY the column names) for a given DB? (I seem to remember doing this before but cant remember how)

Thanks

Mike