Getting fields in a table through a query?

How can I get the fields in a given table via an SQL query even if there are
no records in that table? I just need the names of all the fields in a
table -- is that even possible?

Thanks!

-Mitch