MySQL table/schema FAQ: How do I show the schema of a table in a MySQL database?

Assuming you want to see the schema of a table named orders in a database named restaurant, use these commands from the mysql client (MySQL command line) after logging into your MySQL database:

use restaurant;

desc orders;

The first command (use restaurant) tells MySQL that you want to work in that database, and the second command (desc orders) shows the schema of the MySQL table named orders.