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

By Alvin J. Alexander, devdaily.com

Assume you want to see the schema of a table named orders in a database named restaurant. Use these commands from the mysql command line:

  use restaurant;
  desc orders;

desc orders is the command that shows the schema of the table named orders.


devdaily logo