MySQL FAQ: How do I show the schema of a MySQL database table?
Answer: Use the
desc command from the MySQL command line client.
For instance, in my current application I have a database table named
orders, and when I need to see the schema for that table I show it with the
desc command like this:
The MySQL output looks like this: