Field Name

Can you tell me how to list all the fields of a table in a database? I've tried the "select * from" statement, however, some of the field have data of just one character. Which means the output comes out something like:

M

--
Y

and I don't get to see what the field name is.