SQL question: can I see a table's fields?

[NatuScape]

Hi there!

Is there a form of SQL query code, like a SELECT stamement, perhaps, that can tell me all the columns/fields on a table? I'm very new to SQL and this may be a silly question, so excuse me if it is!

Thanks in advance for your help!

Me :)

[tirebiter]

i didn't think there was, but did a search and found this:

http://forums.mysql.com/read.php?108,33446,35745

[NogDog]

DESCRIBE table_name;

[NatuScape]

Hey there,

Thanks for the info!!

Me :)