From the MySQL console, what command displays the schema of any given table?
Mysql – How to show the schema of a table in a MySQL database
databasedatabase-schemaMySQLschema
Related Topic
- Sql – How to list the tables in a SQLite database file that was opened with ATTACH
- Mysql – How to output MySQL query results in CSV format
- Mysql – Should I use the datetime or timestamp data type in MySQL
- Mysql – How to see what character set a MySQL database / table / column is
- Mysql – How to get a list of user accounts using the command line in MySQL
- Mysql – Difference Between Schema / Database in MySQL
- Mysql – How to import an SQL file using the command line in MySQL
Best Answer
For formatted output:
For an SQL statement that can be used to create a table: