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

Question

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

User · Answer

SHOW CREATE TABLE yourTable    or  SHOW COLUMNS FROM yourTable

User · Answer

SELECT COLUMN NAME  TABLE NAME table schema FROM INFORMATION SCHEMA COLUMNS

User · Answer

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

User · Answer

Perhaps the question needs to be slightly more precise here about what is required because it can be read it two different ways  i e     How do I get the structure definition for a table in mysql  How do I get the name of the schema database this table resides in    Given the accepted answer  the OP clearly intended it to be interpreted the first way  For anybody reading the question the other way try  SELECT  table schema   FROM  information schema   tables   WHERE  table name     whatever

User · Answer

You can also use shorthand for describe as desc for table description      desc  db name  table name    or      use db name     desc table name    You can also use explain for table description      explain  db name  table name    See official doc   Will give output like    ---------- ------------- ------ ----- --------- -------    Field      Type          Null   Key   Default   Extra    ---------- ------------- ------ ----- --------- -------    id         int 10        NO     PRI   NULL                name       varchar 20    YES          NULL                age        int 10        YES          NULL                sex        varchar 10    YES          NULL                sal        int 10        YES          NULL                location   varchar 20    YES          Pune               ---------- ------------- ------ ----- --------- -------

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

Examples related to mysql

Examples related to database

Examples related to schema

Examples related to database-schema