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

mysql database schema database-schema
dlamblin picture dlamblin · Sep 30, 2009 · Viewed 486k times · Source

From the MySQL console, what command displays the schema of any given table?

Answer

Omry Yadan picture Omry Yadan · Sep 30, 2009 
describe [db_name.]table_name;

for formatted output, or

show create table [db_name.]table_name;

for the SQL statement that can be used to create a table.

Related questions

Difference Between Schema / Database in MySQL

Is there a difference between a schema and a database in MySQL? In SQL Server, a database is a higher level container in relation to a schema. I read that Create Schema and Create Database do essentially the same thing …

Read More
Good tool to visualise database schema?

Are there any good tools for visualising a pre-existing database schema? I'm using MySQL if it matters. I'm currently using MySQL Workbench to process an SQL create script dump, but it's clunky, slow and a manual process to drag all …

Read More
Differences between Database and Schema using different databases?

What are the differences in database terminology between MS SQL and MySQL? Can a MySQL instance have more than one database? It appears that it can only create different schemas. However, the SQL command is create database. In MS SQL, …

Read More