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

Question

This is a question I did not find answered in Stack Overflow:

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

The answer is to read about the describe command.

Answer 1

SHOW CREATE TABLE yourTable

or

SHOW COLUMNS FROM yourTable

Bobby

Answer 2

show create table t

or

describe table t

for a nice formated output.